topic Re: Problem with date values not matching (decimals) in QlikView

Problem with date values not matching (decimals)

Mon, 31 Mar 2014 20:13:42 GMT

I have this variable in the load script:

Let vLoadDate = Date(Now(),'M/D/YYYY');

In a table expression I'm trying to compare vLoadDate to QuarterEnd(vLoadDate). However, when comparing them today, March 31 (end of quarter), it says they are not equal. When I look at the values (as a date), they both show 3/31/14. However, when I look as numbers, one shows 41729.370659722 and the other is 41729.99999988.

How can I get them as absolutes so they'll match? I tried using the fabs function, but either it didn't work or I didn't use it correctly.

Thanks, Dan

Re: Problem with date values not matching (decimals)

maxgro — Mon, 31 Mar 2014 20:15:58 GMT

you can use floor function

Re: Problem with date values not matching (decimals)

MarcoWedel — Mon, 31 Mar 2014 22:18:27 GMT

QuarterEnd returns the last millisecond in the Quarter, meaning 23:59:59.999 at the last day in the quarter.

The suggested floor function cuts off the decimal places of the corresponding numerical value, meaning 00:00:00.000 at the last day in the quarter.

regards

Marco

Re: Problem with date values not matching (decimals)

Mon, 31 Mar 2014 22:21:43 GMT

Thanks, that worked great.