Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this and see if this helps (Change in Red
LET vReloadDate = Date($(vCreateDate)-14,'MM-DD-YYYY');
Best,
Sunny
Or this if the above doesn't work:
LET vReloadDate = Date(Date#($(vCreateDate), 'MM-DD-YYYY') -14,'MM-DD-YYYY');