topic difference between 2 dates in days/hrs/mins in QlikView

difference between 2 dates in days/hrs/mins

hopkinsc — Thu, 13 Jun 2013 14:29:51 GMT

Hi,

I am trying to calculate the difference between 2 variables

variables...

vMinDate

vMaxDate

these variables are only dates, so i need to also include the time.so...

vMinDate needs to use the function daystart to make it a timestamp

vMaxDate needs to use the function dayend

example..

vMinDate = '01/06/2013' daystart would make it '01/06/2013 00:00:00'

vMaxDate = '02/06/2013' dayend would make it '02/06/2013 23:59:59

so the duration i need is

1 day 23 hrs 59mins

or it would be perfect to round it up to 2 days.

Is this possible?

Gysbert_Wassenaar — Thu, 13 Jun 2013 14:33:09 GMT

something like this

round(interval(dayend(date#(vMaxDate,'DD/MM/YYYY'))-date#(vMinDate,'DD/MM/YYYY'),'D hh:mm'))

hopkinsc — Thu, 13 Jun 2013 14:35:57 GMT

fantastic, thanks Gysbert