I'm trying to export a Data Extension via a browser download. It is not a large data extension - around 2,000 records. When I open up the exported file (a csv file), I get a mixture of two date formats:
There seems to be no logic to which date format it picks - m/dd/yyyy hh:mm AM/PM or mm/dd/yyyy hh:mm. Can anyone help?