topic Re: End Date - Start Date in QlikView

End Date - Start Date

Anonymous — Wed, 27 Jan 2016 14:27:59 GMT

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 — Wed, 27 Jan 2016 14:38:04 GMT

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 ...;

MK_QSL — Wed, 27 Jan 2016 14:38:48 GMT

You can simply do... Date2-Date1