>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