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! ๐