5 Replies Latest reply: Dec 31, 2015 1:45 AM by Jakob Libak Rasmussen RSS

    Year Boundary 1/1/2012 is 3 yr ago during 1/1/2015 How to set it become dynamic ?

    PAUL YEO

      Hi All

       

      In my script below :-

       

      if(date(@168:179,'DD/MM/YYYY') > '$(YearBoundary3)',dual('No', 0), dual('Yes', 1)) as  [No Sales > 3yr],

       

      In my variable setting , i set YearBoundary3 = 1/1/2012 ( See below image )

       

      Since tomorrow 1/1/2016 , and again 1/1/2012 , the duration is 4 year . which is wrong.

       

      I need to manually change the variable setting to YearBoundary3 = 1/1/2013 , this way is very manual and need maintenance.

       

      Can some one share with me how to make it more dynamic ?

       

       

      year boundary.png