2 Replies Latest reply: May 26, 2014 5:43 AM by Paul Edrich RSS

    Static 'to' Date

    Paul Edrich

      Thanks in advance for your help on this topic...

       

      My objective is to create a script entry to calculate from historical dates to a set period in time which in this instance is static 31/3/2014.

       

      My script currently calculates the historical date to today to give me a 'MonthsAgo' amount like:-

       

      12*Year(today()) - year("HistoricDate")) + Month(Today()) - Month("HistoricDate")  as  MonthsAgo

       

      I have tried multiple combinations of the above replacing Year(today()) with '31/3/2014' which isn't returning the desired result.

       

      Any ideas where I am going wrong?

       

      Regards

       

      P