MailChimp Date format not consistent...

  • 99Views
  • Last Post 20 July 2017
  • Topic Is Solved
0
votes
Paul Johnson posted this 17 July 2017

Hi,

Tried this a couple of times when we export date type information from Mail Chimp... List Members field 'LastUdate' provides a list of dates like this:

LastUpdate

11/02/2016 102

4/26/2017 12:40:18 PM

11/09/2016 104

04/07/2016 09:02

01/11/2017 104

1/28/2017 4:446 PM

08/02/2016 12:55

08/02/2016 12:46

6/21/2016 9:04:55 AM

 

As you can see some of the date fields include AM or PM and some do not? Any clues as to why this is happening? In order to import the data our end we need the date field data to be consistent.

You comments and help would be appreciated - thanks - Paul

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 18 July 2017

We will investigate this behaviour more clearly and contact you as soon as any results are available.

0
votes
Mariia Zaharova posted this 19 July 2017

Please tell us what Locale do you use in your export package? Please open your package editor and click 'More options' (Target connection).

Please try using English (United Kingdom) and notify us about the results.

0
votes
Paul Johnson posted this 20 July 2017

That fixed it! The devils is in the detail... or Locale field ;-)

Close