>Hi Cetin
>
>>It's a known issue with datetime. It is due to how datetime is stored (a silly way IMHO but not VFP's fault):
>>
>>lnTotalSecs = round(EVALUATE(THIS.cToDateTimeField) - EVALUATE(THIS.cFromDateTimeField),0)
>
>Thanks a million, this was driving me whacky.

Yeah did me too years ago too. Whenever you need something like that or search on a column with datatime datatype remember that. ie:

Never search like this:

select * from myTable where myDatetime = m.ltDatetime

But like this:

select * from myTable where ttoc(myDatetime,1) == ttoc(m.ltDatetime,1)

or a similar expression.
Cetin