>I am selecting data from a SQL Server database to display on a grid. Is there a way to display a DATETIME field as a DATE in the grid? I don't need the time data.
>
>Thanks,
>Doug
How are you selecting the data? Remote view? SPT?
If by a remote view, you can change the datatype of the field in the view using DBSetProp('MyTable.MyField', 'Field', 'DataType', "D") function. If SPT, there may be a function to only retrieve the date part of the field in your SQL. I know there is in Oracle.
Mark McCasland
Midlothian, TX USA