2 Replies Latest reply: Dec 8, 2017 12:51 PM by Nawfal Bouharat RSS

    inyeartodate with Date not Month Flag as start of Year.

    Steve Fewster

      Hi All,

       

      I have a company that for commercial reasons has their Sales year starting on 26/12 every year.

       

      I tend to use the following to create my YTD/LYTD flags but I need to replace the Start Month parameter with a specific date?

       

      if(year2date(Inv_Date,0,12),1,Null()) as  Inv_YTD,                                                 
      if(year2date(Inv_Date,-1,12),1,Null()) as  Inv_LYTD,


      Any ideas anyone?


      Cheers


      Steve