Skip to main content

Imports - formatting the date range (EU only) πŸ“…

Ensure your imports go according to plan with this great tip!

Written by Liam Cadle
Updated over 7 years ago

Getting an error message on your imports relating to your date columns? Β This article can help you!

If you are using an import which requires a date range, you will notice on the import rules that the dates need to be formatted as follows;

Year/Month/Day

When using excel, your date formats will generally be in UK/IRE format which is as follows;

Day/Month/Year

For the import to work, we need to ensure we reformat the date field. Β This is a quick fix on your spreadsheet.

Simply highlight the column(s) which contain your dates. Β Right click on the highlighted area and select 'format cells'


Simply select date, and from the locale drop down select English (United States)
​

Hopefully that was easy! Β Our date has now been formatted correctly - I can now import my file into EvolutionX! πŸ‘

Did this answer your question?