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

Technote (troubleshooting)


Problem(Abstract)

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

85365

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Modeler
Modeler

Software version:

13.0

Operating system(s):

Windows

Reference #:

1484208

Modified date:

2011-01-11

Translate my page

Machine Translation

Content navigation