By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
November 20, 2019 3:35 pm
I'm working on writing a comparative report. We have an April 30th year-end, so I like to use written out months and years on reports (rather than period). The formula below shows in the report correctly (i.e. November 2019).
=Format( '{0: MMMM yyyy}',Report.GetPeriodEndDate(@StartPeriod) )
How do I write it to shift the year back one for the prior year comparative column (i.e. I am trying to show November 2018 data). I have tried adding a -1 but I get an error message of "The expression contains a call of an undefined function".
Help and thank you!
3 Replies
December 6, 2019 2:00 pm
Try this
=Format( '{0: MMM d, yy}', DateAdd( Report.GetPeriodEndDate(@StartPeriod), 'm', 1))
December 26, 2019 4:45 pm
Try this for going back one year:
=Format( '{0: MMM d, yy}', DateAdd( Report.GetPeriodEndDate(@StartPeriod), 'y', -1))
January 2, 2020 12:32 pm