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