Date exporting in wrong format

kaledev

Registered User.
Local time
Today, 18:51
Joined
Jan 20, 2011
Messages
19
While exporting my table in a comma delimited file, I noticed my date is re-formatting itself before export. It is currently set in the format of yyyy-mm-dd, but exports as mm/dd/yy 00:00:00.

I thought I would outsmart it by creating a new column as text, and copying it over, then exporting. But when doing that, it copies itself over as mm/dd/yy and I want to pull my hair out. Any ideas? Thanks! :confused:
 
Last edited:
I ended up finding out the answer a little bit after posting. I had to create a query off of the table and format it.

Code:
SELECT Format([Table].[Field],"yyyy-mm-dd") AS FormattedDate......
 

Users who are viewing this thread

Back
Top Bottom