Hi!

Try something like following:
MyCursorAdapter.ConversionFunc = "MyDateTimeField TTOD"

"TTOD" is a converting function. As far as I know, you can put there your own UDF function as well, but it should accept only single parameter and should return a value that goes into the final data cursor.

It might not work in the beta, but most likely would work in the final release.

>Is it possible to convert a SQL Datetime field into a VFP Date field using the cursor adapter. I have code that can obtain the information into a VFP cursor, but I want the datetime field to be a date. I tried setting this in the CursorSchema as a D, but it always creates a datetime.
>
>Any ideas ?
>
>Thanks in advance.
>Simon.