This is the only thing I use it for. We use several date fields that I don't care about the time part. I just convert it to a time field and don't have to worry about it.
>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?