Problem: When exporting lists or analysis data and selecting “Open in Excel”, some date fields are formatted/converted incorrectly. E.g. 06/02/2006 becomes 02/06/2006.

Or, Excel doesn't always recognize 'Date & Time' fields properly when it includes a seconds value.

This bug only appears with 'Date & Time' fields, and not with 'Date' fields. I.e. fields that only display a date without the hour:minute appear correctly in Excel.

This is a known issue with Excel that ignores date formatting instructions when the time is included in the value.

Workaround: Use the manual import wizard in Excel which seems to use different code:

1. Do not select “Open in Excel” and export to CSV only.
2. Load Excel, select File/Open and open the CSV file you exported.
3. Manually import the file and optionally set the date format for the column in question.