Modify the remote view, click the properties button, and change the Data Type under Data Mapping.



>Now this solution sounds interesting, yes we are using remote views. This could work well until we established more control over our edits (as J suggests). However, I am unaware of the secret of changing the data type on a column in a view. How do you we do this magic feat?

>...tim

>>Are you using remote views?
>>
>>If so, you can set the data type to the fields in the view to DATE and the time portion will be dropped.
>>
>>>>>We have upsized our tables to a SQL server and the DATE columns have been converted to DATETIME data type. This change has annoyed our secretaries and we are looking for a simple solution. I have experimented with FORMAT and INPUTMASK but have not been able to get rid of the time portion of the data.
>>>>
>>>>>How is everyone dealing with this change?
>>>>
>>>>>…tim
>>>
>>>>You can use TTOD() to display only the date portion of a datetime var. This is on the VFP client right?
>>>
>>>>When sending to SQL Server, you can send only the date portion if you don't care about the time.
>>
>>>Yes, VFP 6.0 and how are you binding the form control to the data?