Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

expression for datetime in difference

Hi All,

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

2 Replies

Re: expression for datetime in difference


use interval() .


inetrval(date2-date1,'D hh:mm')

If you dont want in hr and mins then remove HH mm

For details check in help file.


Great dreamer's dreams never fulfilled, they are always transcended.
Esteemed Contributor

Re: expression for datetime in difference

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