By using this website, you agree to our Terms of Use (click here)
Are you trying to display both the Start Date (not Start Period) and the End Date (not End Period) at the top of your financial reports?
If so, I learned something recently that I thought I'd share.
Let's say you have a report that accepts both a Start Financial Period and an End Financial Period like this:
You can use the following formula in your Column Set:
=Format('{0:MM/dd/yyyy}',Report.GetPeriodStartDate(@StartPeriod))+' - '+Format('{0:MM/dd/yyyy}',Report.GetPeriodEndDate(@EndPeriod))
This will display both the Start Date and End Date at the top of your report like this:
Hi Tim
Has anything changed with this function during the master calendar change?
I keep getting this error when trying to use it...
The expression contains a call of an undefined function GetPeriodStartDate()
Thanks for your help 🙂
Never mind - didn't register that this topic was around the Analytical Report writer... I'm trying to achieve this in the normal report writer.
Online Members