Discussion board where members can get started with QlikView.
i have two date fields like date1 and date2.
date1 has value 2014-08-30 05:03:16.000
date 2 has value 2014-08-30 10:02:36.000
i want to find out the difference between date2 and date1 and need the output like 4.59....
Please let me know how its done..
Attached is the document. Hope it helps.
but the output become 4.12.20.. i need it as 4.59
Let me suggest some changes to the solution you uploaded.
=time([date 2]-date1, 'HH:MMS')
The mask 'HH:MMS' is incorrect. It should be 'hh:mm:ss' (lower case). "MM" means "Month", which gives an incorrect result.
I believe the best function to use here is "interval()" rather than "time()". Time will give an incorrect result if the difference is greater than 24 hours. The solution I suggest is:
=interval([date 2]-date1, 'hh:mm:ss')
Thank you very much Rob.
hope this helps