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:
4/26/2017 12:40:18 PM
1/28/2017 4:446 PM
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