>I apologize since I know this has been answered before (most probably by Sergey ;) ), but I forgot to file it in my tips folder.
>
>I'm retrieving SQL Server data using SPT to a cursor which contains, among other things, a datetime field. I have a textbox control in a grid that I would like to use for displaying this field as a date only. How do I achieve this? Changing the SELECT statement to convert the datetime field to a style of 101 doesn't help at all. Am I to use TTOD() somewhere in this?
>
>Laterness,
>Jon
If for display only then simply set controlsource to '(ttod(alias.fieldname))'
In VFP8 you could use CursorAdapter.CursorSchema to set the datatype as date.
Cetin