Exporting Date using Query

  • Thread starter Thread starter Ken
  • Start date Start date
K

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?
 
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?
Click to expand...

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.
 
Back
Top