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.