expression for datetime in difference - Qlik Community

Report Inappropriate Content · ‎2014-05-17

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

PrashantSangle · ‎2014-05-17

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

SunilChauhan · ‎2014-05-17

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

Sunil Chauhan