Discussion Board for collaboration related to QlikView App Development.
I want write expression for difference between to datetime fileds :
Ex : Date1 :03/20/2013:08:23:25
Date2 : 04/20/2013:17:32:02
difference between these 2 dates in expression side.admin
use interval() .
If you dont want in hr and mins then remove HH mm
For details check in help file.
actully see below
i am assuming date 2 is greater
age(date2,date1) returns difference in days
inetrval(date2,date1,'hh') for difference in hours
inetrval(date2,date1,'mm') for difference in minutes
hope this helps