Could not identify DATE

pantangi_shekarpantangi_shekar Member Posts: 9 Contributor I
edited December 2018 in Help

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

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    You need to use a Nominal to Date opeartor and set it correctly to yyyyMMdd

  • Edin_KlapicEdin_Klapic Moderator, Employee, RMResearcher, Member Posts: 299 RM Data Scientist

    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

Sign In or Register to comment.