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