I am trying to use the script build a calendar table that will identify dates that fall in various historic financial years (Month 1 is May). The following code works for the current financial year and the previous financial year:-
-1*(Year2Date(Date(CtrlDate),0,5,$(vToday))) as IsWithinFinYTD,
-1*(Year2Date(Date(CtrlDate),-1,5,$(vToday))) as IsWithinLastFinYTD
I also need to identify the year before the last financial year but all my attempts have failed.
Any suggestions please?