difference between 2 dates in days/hrs/mins

[hopkinsc]

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 · Accepted solution]

something like this

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

[hopkinsc]

fantastic, thanks Gysbert