Could not identify DATE

pantangi_shekar
pantangi_shekar New Altair Community Member
edited November 2024 in Community Q&A

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.

Tagged:

Answers

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

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

  • Edin_Klapic
    Edin_Klapic New Altair Community Member

    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