Thank You
Greg
>>Hi All,
>>
>>I am comparing 2 dates and getting unexpected results:
>>
>>Here is what is displayed in the Debugger watch window:
>>
>>
>>
>>c_ScanCursor.dDateField {5/21/2004}
>>dDate2Match {5/21/2004}
>>c_ScanCursor.dDateField = dDate2Match .F.
>>vartype(c_ScanCursor.dDateField) "D"
>>vartype(dDate2Match) "D"
>>SET("Strictdate") 0
>>
>>
>>
>>What Gives ???
>>
>>TIA
>>
>Greg,
>
>When adding non-integer values to dates or large integers to datetimes, it may cause the system to make the calculation in terms of 8 byte double precision floating point numbers. With some values, the calculation may cause the system to exceed the 15 digit limit of precision with these numbers, and, thus, errors like these appear.
Greg Foote
Software At Work, Inc.