>>>>>>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?
>>
>>That’s pretty much it, you didn’t miss anything. I would like to avoid a form intensive design, such as adding properties to the form. I think I would rather buffer the data with a conversion process during the save/edit. I really want to keep the form design a simple as possible so we can involve some Access people in the form design. What other ideas do you have and thanks for the responses so far…
>>
>>…tim
>
>You can also implement a data object. This could be a property of an application object or a public var. I am not sure I understand what you mean by buffering the data with a conversion process.
>
>How will this affect the Access people? Do you mean you are involving Access programmers in the VFP project?

Sure, do a scatter on the form load to an an object or objects and convert the datatype within the object to DATE for the edit session and back to DATETIME on the save.

Sure, we have several people who have built forms in Access and they understand the idea well enough that we would like to ship them some VFP forms for them to work with. I do not care for the work of modifying forms and would much rather farm that off, if possible...

...tim