Forum Discussion
Comparison Date (Year on Year)
Bit of a complex one, but I am trying to create a Comparison Date in my Calendar Table so individual days can be compared year over year with the current year's date being the end result. The compari...
That is awesome, thank you so much. I really appreciate your help.
Would be great if you could explain how that custom column is working, as I haven't seen "inner" used before.
One thing, is it possible to have the Comparison Date to show for this year (when its next year roll to 2023 etc.) so future dates in the calendar work? I am guessing incorporating something like the below so it doesn't go past the end of the current year.
Date.EndOfYear(Date.From(DateTimeZone.RemoveZone(DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(), +10))))
For example if you expand the calendar out now the comparison date goes to the max date of the calendar.