topic How to calculate the time difference between two different date? in QlikView

How to calculate the time difference between two different date?

Wed, 03 Oct 2012 04:15:54 GMT

Hi All,

Good Morning....!

I have issue with date.

I want to calculate time difference.

For Ex:

We have two date like this

End date = 2012/10/02 11:55:25 PM.

Start Date= 2012/10/03 01:55:26 AM.

want_date= End date -Startdate

I want a 'want_date' as Minitues.

Thanks in Advance,,,.

Regards,

Kabilan K

Anonymous — Wed, 03 Oct 2012 05:03:44 GMT

=Interval(Enddate-Startdate, 'mm')

This is assuming that your timestamps are recognized correctly in QV.

Works fine if you define them like this:

let Startdate = num(timestamp#('2012/10/02 11:55:25 PM','YYYY/MM/DD hh:mm:ss TT'));

let Enddate= num(timestamp#('2012/10/03 01:55:26 AM','YYYY/MM/DD hh:mm:ss TT'));