>>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

He is using SQLExec (or SQL Pass Thru) which means he isn'yt using a remote view.

BOb