By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,221 Members | 1,121 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,221 IT Pros & Developers. It's quick & easy.

Convert Dates in Exported CSV file

P: 1
I am trying to create a CSV export file that has a date field. If you look at the table in Access the date looks like mm/dd/yyyy.

I want to run the export wizard to create a spec so I can use it in a Transfertext.

I am trying to convert the date to dd-mm-yyyy.

I selected the - as the separator and the format as DMY.

When I look at the exported file, some dates are MM/DD/YYYY and some dates are DD-MM-YYYY.

Why are only some of the dates converted?

I checked the file and all dates in the column of the original table seem good (MM/DD/YYYY).

Thank you for any help received.
Feb 17 '09 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,419
What is the type of the field in the Access table where these dates are stored?

I suspect that it is string rather than DateTime. Remember, strings can look like almost any other standard field type.
Feb 17 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.