Date format when exporting

  • Thread starter Thread starter mike
  • Start date Start date
M

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

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")
 
Back
Top