The current date is being entered in place of the date in the field. This data is comming from a SQL 7 database using SQLE(...). The orig datatype is smalldatetime. This only happens when I get a result set from SQL, VFP tables with a DateTime field seem to work ok. I can't really go straight to ADO from SQL since I need to do some touching up and join in some VFP lookup data before passing the ADO rs on.

Bill

>Hi Bill..
>
>When you say the DateTime Fields are wrong, what do you mean by "wrong"?
>
>Unless one knows what is wrong, one cannot know the issue...< bg >...
>
>< JVP >
>
>
>>I am creating Crystal Reports for my web site now. Whenever I use cur2rs to convert my cursor to ado to pass to the CR report, all the DateTime fields are wrong. Is this a know issue? Is there a work around? Now I do a second query with a TTOD() on any datetime fields.
>>
>>TIA
>>Bill