IBM Support

Excel dates don't get imported correctly into IBM SPSS Modeler 13

Technote (troubleshooting)


I added an Excel source node to my stream and I referred to an *.xlsx file that contains some dates. When importing the dates into IBM SPSS Modeler 13, they don't get imported correctly, instead, a 3 digit number is displayed, why is this happening ?

Resolving the problem

This has been resovled in IBM SPSS Modeler patch 13.0.2.

This problem is caused by an incorrect date value in the xlsx file. For example : the date format that was set for the column was "dd/mm/yyyy" but the Excel file contained a value "11-2009". Once this value gets fixed and matches the format of the column, all dates should be imported correctly into IBM SPSS Modeler 13.
An other workaround would be to open the the *.xlsx file in Excel and to save it as an *.xls file, when you import the *.xls file afterwards, the result should be correct

Related information

Need more help? Our Modeler forum is Live!

Historical Number


Document information

More support for: SPSS Modeler

Software version: 13.0

Operating system(s): Windows

Reference #: 1484208

Modified date: 07 September 2016

Translate this page: