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