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

Open your view in the View Designer, select properties, find the field you wish to change from DT to D in the field pull-down list, then change the data type under the Data Mapping session from DateTime to Date.

Regards,

MOnTe