Could not identify DATE

Hello all,
I have a column named DATE which has values in the following way
DATE
20100321
20100427
When I imported the dataset(where the DATE column is taken as integer) and used "type operator - NUMERICAL TO DATE", the result was surprising. All the dates are in the following way
DATE
jan 1, 1970
jan 1, 1970
Did anyone face this issue? I do not know how to change the format of the DATE column so that rapidminer could recognize it as a date.
I appreciate your help and thanks in advance.
Best,
Raj.
Answers
-
You need to use a Nominal to Date opeartor and set it correctly to yyyyMMdd
2 -
Hi,
The issue with Numerical to Date is that is interprets the numerical value as milliseconds starting from a certain point in time, i.e. Jan 1st 1970.
I recommend the solution Thomas proposed but be sure to import the Data not as integer but as nominal.
Best,
Edin
0