>I have a Grid with date column. Rowsource of this grid is a cursor. The cursor is created from the SQL Server. SQL Server gives me date with time. The problem is I don't want to show the time part in the Grid. And If I convert it into the charater while fetching from the SQL Server, in the grid it will become the char type column.
>
>Thanks,
>Rajni
Have an additional column that is converted using TTOD() and hide the original column. In the Valid of the textbox in the column, save it back to the datetime field.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer