reversing dates from yyyymmdd to mmddyyyy

W

will rudloff

we exported to an excell spread sheet and the dates are reversed. we wanted
mmddyyyy and they come into spread sheet yyyymmdd
 
J

Jerry Whittle

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

Excel --> Word 4
Converting Text to Date 3
Bugs in Office 2019 0
Adding data to MS Access from csv file 0
Date format on exporting query to csv file from access 2007 3
convert date to different format 4
Need to convert MMDDYY to YYYYMMDD! Help please! 3
Format of text date 4

Top