End Date - Start Date - Qlik Community

Anonymous · ‎2016-01-27

HI All

I have 2 dates

Start date and End date

I want to create the following sum in script

End Date - Start date = eg...20

Any ideas?

Thanks

swuehl · ‎2016-01-27

If your dates are intepreted as such, they will hold a numeric representation.

You just need to set the date / timestamp format correctly in the script or use Date#() / Timestamp#() functions.

Then the calculation shoud work

SET DateFormat = 'MM/DD/YYYY'; //use your date format here

LOAD

EndDate,

StartDate,

Interval( EndDate-StartDate ) as Duration

FROM ...;