G Guest Feb 15, 2006 #1 we exported to an excell spread sheet and the dates are reversed. we wanted mmddyyyy and they come into spread sheet yyyymmdd
we exported to an excell spread sheet and the dates are reversed. we wanted mmddyyyy and they come into spread sheet yyyymmdd
G Guest Feb 15, 2006 #2 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")
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")
