Could not identify DATE

User: "pantangi_shekar"
pantangi_shekar
New Altair Community Member
Updated by Jocelyn

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.

Find more posts tagged with

AI Studio
Sort by:
1 - 2 of 21
    User: "Thomas_Ott"
    Thomas_Ott
    New Altair Community Member

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

    User: "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

Quick Links