topic Date subtraction logic in App Development

Date subtraction logic

Tue, 19 May 2015 17:00:46 GMT

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!

Re: Date subtraction logic

sunny_talwar — Wed, 20 May 2015 15:20:25 GMT

Try this and see if this helps (Change in Red

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

Best,

Sunny

Re: Date subtraction logic

sunny_talwar — Wed, 20 May 2015 15:21:52 GMT

Or this if the above doesn't work:

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