Financial periods

[Anonymous]

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

[sunny_talwar]

Can you try one of these:

Max(DISTINCT CDate, -13)

or

AddYears(Max(CDate), -1)