>Does anyone know how to just return the date and not the time from ms-sql server when you use sqlexec ?

You can use convert... but, since Date is not a type in SQL server you would have to 'convert' it to a varchar. You could also create a cursor with the field as a date, and append your SQL cursor into the normal cursor.

If you use a view you can set the field to a date type... I don't see a way to change the type after you have got the cursor.

BOb