Days between a date and last day of the year

building reports webintelligence legacy
1

Hi all,

I’m searching for a formula which gives me the days between a date and the last day of the year. I something possible?

Many thanks
Denise

esined (BOB member since 2011-07-05)

2

If the End of Year date is available as a dimension in your universe, then use:

=DaysBetween([Date];[EOY Date])

Otherwise you could hard-code it as

=DaysBetween([Date];‘31/12/2011’)

mpwalker :uk: (BOB member since 2008-11-06)