Date format when exporting


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

Advertisements

T

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
 
Ad

Advertisements

J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top