>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