1

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?

2 Answers 2

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.

1
  • 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, 2017 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .