You're welcome!
>Hi Sergey
>
>That worked very well.
>
>Thank you
>Jim
>
>>>Hello Group
>>>
>>>I have a report based on a table in an SQL Server 7.0 I am using FoxPro 6.0 as the front end. I have a field Birthday that displays 10/7/1975 12:00:00 AM and I would like it to display 10/7/1975. I played with the properties for that field with no luck. Some one said use ttod() I tried this on the field in the view but got an error that this function was not heard off.
>>>
>>>What do I need to do.
>>>
>>>Thanks
>>>Jim
>>
>>You can put TTOD(mydatetimefield) into the field expression on the report.
--sb--