>>I've noticed that Calculations involving DateTime Values combined with INT, MOD or / sometimes act strangely
>>
>>For Example:
>>
>>I've observed the following:
>>
>>X = {04/22/1999 16:00:00} - {04/22/1999 15:00:00})
>>?INT(X/60)
>>
>>X = ROUND({04/22/1999 16:00:00} - {04/22/1999 15:00:00}, 2)
>>?INT(X/60)
>>
>>
>>The First result yields the incorrect number of 59
>>
>>The Second pass yields a correct number of 60.
>>
>>
>>I suspect that the problem has to do with how VFP internally handles precision as regards to datetime calculations.
>>
>>Marshal Rosenberg
>>Marshal_Rosenberg@Compuserve.Com
>Yes, Datetime is a real value expressed as Date + (seconds/86400) in calculations. So division precision affects the result.
X = {04/22/1999 16:00:00} - {04/22/1999 15:00:00}
>? x*1.0000000
>? int(x*1.00)
>? int(int(x)/60)
>? int(int(x*1.00)/60)
>X = int({04/22/1999 16:00:00} - {04/22/1999 15:00:00})
>? int(x/60)
Cetin
Hi Cetin,
Thanks for your help.