Discussion Board for collaboration related to QlikView App Development.
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?
=Date1 - Date2
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])
View solution in original post
I am getting all integers:
Or can just use Interval():