How to calculate the time difference between two different date?

[#1]

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

=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'));