Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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!

2 Replies
MVP
MVP

Re: Date subtraction logic

Try this and see if this helps (Change in Red

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


Best,

Sunny

MVP
MVP

Re: Date subtraction logic

Or this if the above doesn't work:


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