This content has been marked as final. Show 3 replies
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.