Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted

Re: expression for datetime in difference

Hi,

use interval() .

Like,

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

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

For details check in help file.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
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