>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only