0

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:

enter image description here

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?

1

Format Cells Hope it can help. I think you can use the 'Format Cells' functionality and choose the 'Date' in Excel. Then you can get the format you wanna.

  • Thanks but when I do that, it converts those in the short format, but does not convert the ones in the longer format - I think it is reading those as text format rather than a date. – TCassa Jul 7 '17 at 14:15
0

It seems a datetime field in your CSV. You need to set the format of the column and then do the load.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.