2 Replies Latest reply: May 20, 2015 11:21 AM by Sunny Talwar RSS

    Date subtraction logic

      HI All,

       

      I'm trying to subtract 14 days from a date variable vCreateDate := '05-14-2015'

       

      For this, I tried following the simple method as shown below:

       

      LET vReloadDate = Date($(vCreateDate),'MM-DD-YYYY') - 14;

       

      The value I receive is '06-01-1894' instead of 14 days being deleted from the vCreateDate variable. I tried using the Interval function but that does not work either.

       

      Any suggestions will be appreciated.

       

      Thanks!