reversing dates from yyyymmdd to mmddyyyy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

we exported to an excell spread sheet and the dates are reversed. we wanted
mmddyyyy and they come into spread sheet yyyymmdd
 
Create a query based on the table(s) which you want to export to Excel. On
the date field use the Format function to show the data like you want
exported. Export the query.

FormattedDate: Format([YourDateField], "mmddyyyy")
 

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

Similar Threads

Converting Text to Date 3
Need to convert MMDDYY to YYYYMMDD! Help please! 3
convert date to different format 4
Dates in Export Specification Inconsistent in results 1
Date format on exporting query to csv file from access 2007 3
I need to convert a series of DOB's from yyyymmdd to mmddyyyy 1
Date Conversion 6
Date Conversion 2

Back
Top