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?