topic Re: difference between time in QlikView

difference between time

Wed, 02 Oct 2013 10:28:22 GMT

Hi I have 2 datetime fields and I want to calculate difference between 2 fields of time

ex: date1 = 2010-11-19 09:22:09.000 date2 : 2010-11-19 11:52:38.000

then date3 =date2- date1 i.e (11:52:38.000-09:22:09.000).

how to caluclate it.

israrkhan — Wed, 02 Oct 2013 10:37:57 GMT

Hi Pankaj,

Did you try interval(EndTime-StartTime, 'hh','mm')

Timestamp(Timestamp#(EndDateTime) - Timestamp#(StartDateTime), 'hh:mm:ss')

Khan

Wed, 02 Oct 2013 11:21:51 GMT

I tried first one but some times it shows wrong means

Ex : Date1 = 12:56, Date2 : 19.43 then date3 returns = 6:47 but actually value is = 6:87

Clever_Anjos — Wed, 02 Oct 2013 11:28:22 GMT

time(frac(date2) - frac(date1))

Anonymous — Wed, 02 Oct 2013 11:29:51 GMT

Hi Pankaj,

there is the Interval function, that calculates the difference between 2 dates:

Try using as below:

Interval( Date('2010-11-19 09:22:09.000') - Date( '2010-11-19 11:52:38.000'), 'hh:mm:ss')

Interval( Date('19:43') - Date( '12:56'), 'hh:mm:ss')