Import the registration date is not good.

[schyzo]

Hello,
on import the registration date is not good.
Example: 05/04/2018 09:30:00 import –> 04/05/2018 09:30:00
The import reverses the day and the month
Thanks for your help
David

[Andras]

Hi David,

Thanks for getting in touch!

Sorry to hear you are having troubles with the import. I can help you with this one.

The importer cannot recognize the date format that is in the CSV file, as the CSV file doesn’t contain that information, it contains only numbers.

Here’s a section from our knowledgebase that explains how you can work with this:

It’s important to remember that some date formats can be rather ambiguous! For example, 05/06/2016 could be interpreted either as May 6th or as 5th June. It’s important to note that the former style, more common in North America, is assumed by the importer. If you prefer to use the alternative format, with the day first and month second, you can do so—but please use hyphens instead of slashes, i.e. 05-06-2016.

And here’s the full article and one more to give you a full picture:

• https://theeventscalendar.com/knowledgebase/csv-files-options-and-examples/
• https://theeventscalendar.com/knowledgebase/importing-data-from-a-csv-file/

Let me know if this helps.

Cheers,
Andras

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts