topic Re: DATE DIFFERENCE in QlikView

DATE DIFFERENCE

hkg_qlik — Thu, 05 Dec 2013 22:32:28 GMT

Hi I have 2 dates :

START DATE

END DATE

START DATE : 11/01/2013 20:00:00

END DATE : 12/01/2013 15:00:00

The difference should display : 30 Days 5 Hrs (Something like this which convert the difference into Days and hours)

Currently using Expression : =Interval( [END DATE] - [START DATE],'D')

hic — Thu, 05 Dec 2013 22:54:16 GMT

If the two dates are interpreted correctly, you will get 30 - 5/24 = 29.79 . The Interval function is not necessary. Hence:

Timestamp#('12/01/2013 15:00:00','MM/DD/YYYY hh:mm:ss') -

Timestamp#('11/01/2013 20:00:00','MM/DD/YYYY hh:mm:ss') as Interval,

HIC

angelaecheverri — Fri, 06 Dec 2013 03:04:33 GMT

Try

ceil( [END DATE], 1) - ceil([START DATE], 1

ceil( 2.4 ) =3

ceil( 2.6 ) = 3

ceil( 3.88 , 0,1 ) = 3,9

ceil( 3.88 , 5 ) = 5

ceil( 1.1 , 1 , 0.5 ) =1,5