Date format when exporting

[mike]

The date format of my query export to csv keeps howing as mm/dd/yyyy 0:00. I
only want to show mm/dd/yyyy.

My regional settings are set to short date as are the fields in the import
table and query.

Help!!!

 

[Tom van Stiphout]

On Tue, 10 Nov 2009 19:23:20 -0800, mike

You are probably trying to export a table. Export a query instead,
which you will have properly formatted.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

The date format of my query export to csv keeps howing as mm/dd/yyyy 0:00. I
only want to show mm/dd/yyyy.

My regional settings are set to short date as are the fields in the import
table and query.

Exports ignore the table (or query, sorry Tom) formatting. But you can use the
Format() function in a query to explicitly cast the date value as a string.
Create a query based on the table; omit the date/time field; instead put in a
calculated field

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