Contracts - Date error when importing xls
Hi,
I get an error when trying to import an .xls-file into the contracts module.
I read in another thread that the cells that holds the information about the dates needs to be formatted correctly for the import to work, and i've tried formatting the cells but i still get the error.
SDP 9305, MSSQL
1) Date parsing error : Unparseable date: "2012.12.31" 2701,TeliaSonera 4058679,Maintenance,,TeliaSonera,,,,2010.01.01,2012.12.31,0.0,,,,, 2) Date parsing error : Unparseable date: "2013.03.31" 901,Dell Klientavtal,Maintenance,,Dell AB,,,,2012.05.25,2013.03.31,0.0,,,,, 3) Date parsing error : Unparseable date: "2013.03.31" 902,Dell Server & Lagringsavtal,Maintenance,,Dell AB,,,,2012.05.25,2013.03.31,0.0,,,,, 4) Date parsing error : Unparseable date: "2013.12.31" 3002,Sjunet anslutningsavtal,Maintenance,,Inera AB,,,,2011.01.01,2013.12.31,0.0,,,,,
Regards,
Alexander Nordin
Region Halland