topic Date difference in QlikView

Date difference

Fri, 21 Aug 2015 20:21:28 GMT

Hello

I'm doing some data validation on two date fields that should be one year apart and found something interesting. I use Date1-date2 and was expecting to get either 365 or 366, however I got some non integer as well. Any idea why?

Date 1	Date 2	=Date1 - Date2
12/22/2012	12/22/2011	366
10/16/2014	10/16/2013	365
10/19/2014	10/19/2013	365
10/23/2014	10/23/2013	364.303588
1/7/2015	1/7/2014	364.3483333
1/15/2015	1/15/2014	365

Re: Date difference

sinanozdemir — Fri, 21 Aug 2015 20:26:24 GMT

I am getting all integers:

Re: Date difference

sergiorey — Fri, 21 Aug 2015 20:38:17 GMT

Hi,

May be it is taking hour/minutes/seconds in consideration.
Please try using Floor function so as to consider only the date, like this:

Floor([Date 1]) - Floor([Date 2])

Regards,

Sergio.

Re: Date difference

sinanozdemir — Fri, 21 Aug 2015 20:40:11 GMT

Or can just use Interval():