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