Skip to main content
All CollectionsAdvanced HelpImports
Imports - formatting the date range (EU only) ๐Ÿ“…
Imports - formatting the date range (EU only) ๐Ÿ“…

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

Liam Cadle avatar
Written by Liam Cadle
Updated over 6 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?