>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
I know how to do this with a remote view. Did you try ALTER TABLE to change the field from a datetime to a date field?
BOb
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only