Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=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'));
=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'));