Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need financial periods. I created following variables. comparing Previous FY count Vs Current FY count.
max(CDate,-13) and max(CDate,-12) retunes 02/29/2016. I need 02/28/2015.
max(CDate) = 02/29/2016
min(CDate)=04/01/2014
min(CDate,13)=04/01/2015
max(CDate,-13) =02/29/2016
Thanks,
Krishna
Can you try one of these:
Max(DISTINCT CDate, -13)
or
AddYears(Max(CDate), -1)