You know I never really noticed that properties button before. I suppose during my first exploration of remote views I somehow got the idea that this was one of those areas were things were better left alone. Do you use the view properties quite a lot and what might you suggest for dos and don’ts?

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