Discussion board where members can get started with QlikView.
I have issue with date.
I want to calculate time difference.
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,,,.
Go to Solution.
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'));