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

Well, now that you switched to Client/Server you may want to try a different approach to data binding. One of them could be form properties for each field and assign them to the control's ControlSource property. This way you can get better control when the data is saved to the local cursor / recordset, or when the data is submitted to the backend.

Was that your question or did I miss something?