topic expression for datetime in difference in QlikView

expression for datetime in difference

Sat, 17 May 2014 07:17:31 GMT

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 — Sat, 17 May 2014 07:21:11 GMT

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,

SunilChauhan — Sat, 17 May 2014 07:35:14 GMT

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