Excel Importer XLSX unable to parse date

I have just set up the Excel Importer in a project and created my initial template. When importing a .XLS file this works fine When i try to import the same file but in a .XLSX format I get the following error: java.text.ParseException - Unparseable date: "01/07/16" can anyone shed any light on what may be causing this issue or a way around it?
1 answers

Hi Jordan,

If you trying to import just an attribute that is of type datetime then ensure that the date is formatted ‘mm/dd/yyyy’.

The date should look like 1/12/2020 and not 01/12/2020.

This worked in my cases, and I found that if the date was structured 01/12/2020, even though it was a date, it could not be parsed.