How to calculate Difference between time intervals?

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

Hello all,

 

Is there a way to caliculate the time difference between two intervals in rapid miner?

 

For example,

 

I have two columns in my dataset named ADMISSION_DATE and DISCHARGE_DATE. I want to know the difference between those two dates in number of days.

 

Admission_date               Discharge_time

JAN 14 2017                    JAN 18 2017

 

I need to have an other column like this

 

Difference

4

 

Thanks in advance.

 

Best,

Raj.

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "Thomas_Ott"
    New Altair Community Member
    Accepted Answer

    Yes, use a Generate Attributes operator and the date_diff function. Just make sure that RapidMiner has those dates in the date-time format.