Exporting Date using Query

[Ken]

I have a table which I export to a text file. Within that Table are date
fields. When I export the date field it appears as 11/10/2008 00:00:00.

All I required is the date. How can I achieve this?

 

[John W. Vinson]

I have a table which I export to a text file. Within that Table are date
fields. When I export the date field it appears as 11/10/2008 00:00:00.

All I required is the date. How can I achieve this?

Create a Query based on the table. In that query put a calculated field:

ExpDate: Format([datefield], "mm/dd/yyyy")

and include all the other fields you need exported.

Export this instead of the table.