>Thanks All for your replies.
>I solve the problem!
>
>The thing was in the date field.
>I create a new field as string in the table and a trigger for update that fills the original date field using CTOT function.
Esteban,
I would come to this point :) CTOT is dangerous IMHO. Instead :
transform(ttoc(ltDateTime,1), '@R 9999/99/99 99:99:99')
or for a date :
transform(ttoc(dtot(ldDate),1), '@R 9999/99/99 99:99:99')
provide needed ODBC canonical format. It's free from any century, set date etc settings which might affect CTOT.
Cetin