Format of "Registration Date" in CSV export

Hi guys,

I’ve noticed something kinda weird with my CSV exported data, namely in the Registration Date field:

Some of the dates in here are written in plain text (eg. 02/13/2012
), while others are as a serial number (eg. 41031). So some of them are displaying correctly as dates within Excel, while others are not sorting or displaying correctly because they are dumb text, rather than the proper entry. Any idea what’s going on here? I can’t see any pattern to the occurence; it appears in blocks, so my first user is text, 2-23 are serial, next 30 odd are text, next 10 or so are serial numbers… Very strange!

Any ideas?

Also, I noticed that you guys have finally fixed the export thing so data is arranged properly, which fixes a bunch of MailChimp issues I was having. Yay! Thanks :)

– Andrew

it appears in blocks, so my first user is text, 2-23 are serial, next 30 odd are text, next 10 or so are serial numbers… Very strange!

Yes, that sounds quite strange… Have you tried these? Knowledge Base » Common Troubleshooting Tips

Also, I noticed that you guys have finally fixed the export thing so data is arranged properly, which fixes a bunch of MailChimp issues I was having. Yay! Thanks :)

Great! :)