topic Help with Year2Date Function Please? in QlikView https://community.qlik.com/t5/QlikView/Help-with-Year2Date-Function-Please/m-p/308209#M113807 <HTML><HEAD></HEAD><BODY><P> I am trying to use the script to 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:-</P><P>-1*(Year2Date(Date(CtrlDate),0,5,$(vToday))) as IsWithinFinYTD,</P><P> -1*(Year2Date(Date(CtrlDate),-1,5,$(vToday))) as IsWithinLastFinYTD</P><P>I also need to identify the year before the last financial year but all my attempts have failed.</P><P>Any suggestions please?</P><P>Thanks,</P><P> Chris</P></BODY></HTML> Tue, 21 Jun 2011 21:12:13 GMT 2011-06-21T21:12:13Z Help with Year2Date Function Please? https://community.qlik.com/t5/QlikView/Help-with-Year2Date-Function-Please/m-p/308209#M113807 <HTML><HEAD></HEAD><BODY><P> I am trying to use the script to 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:-</P><P>-1*(Year2Date(Date(CtrlDate),0,5,$(vToday))) as IsWithinFinYTD,</P><P> -1*(Year2Date(Date(CtrlDate),-1,5,$(vToday))) as IsWithinLastFinYTD</P><P>I also need to identify the year before the last financial year but all my attempts have failed.</P><P>Any suggestions please?</P><P>Thanks,</P><P> Chris</P></BODY></HTML> Tue, 21 Jun 2011 21:12:13 GMT https://community.qlik.com/t5/QlikView/Help-with-Year2Date-Function-Please/m-p/308209#M113807 2011-06-21T21:12:13Z