0 Replies Latest reply: Jun 21, 2011 5:07 PM by chriswa RSS

    Help with Year2Date Function please?

      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?

      Thanks,

      Chris