3 Replies Latest reply: Mar 31, 2014 6:21 PM by Dan Magnus RSS

    Problem with date values not matching (decimals)

      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