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

Historical Number


Document information

More support for:

SPSS Modeler

Software version:


Operating system(s):


Reference #:


Modified date:


Translate my page

Content navigation