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.