SDPlus - Contract import fails to parse xls date
I have tried to import contracts (to save time) and would have been quicker entering them manually! The xls is saved with date format yyyy-mm-dd, but I keep getting this parsing error:
Date parsing error : Unparseable date: "19 Nov 2017, 00:00:00"
I have tried (many times) to use the failedContractsList.xls - when I open it the date appears as 19 Nov 2017, 00:00:00. I delete the ", 00:00:00" but the error keeps happening!
BTW I am using Office 2016.
Date parsing error : Unparseable date: "19 Nov 2017, 00:00:00"
I have tried (many times) to use the failedContractsList.xls - when I open it the date appears as 19 Nov 2017, 00:00:00. I delete the ", 00:00:00" but the error keeps happening!
BTW I am using Office 2016.