I'm retrieving data from an ODBC data souce. One of hte fields is a date field however, when I show it in a datagrid it is also displaying a time stamp.

Anyway I can get just the date? I've tried setting the column type to "String" but no luck. I've also tried to return just the date portion to the column but it still tacks on the time portion. Any/all suggestions are appreciated. Thanks.

Perhaps using the TO_CHR(<fld>, 'dd-mon-yyyy') (substituting the particular formatting characters for what you are after) function (or TO_CHR()’s equivalent in your RDBMS) in the SQL to get the DBMS to return just the part you want.