How to calculate Difference between time intervals?

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

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.

Tagged:

Best Answer

  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    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. 

Answers

  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    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. 

  • Telcontar120
    Telcontar120 New Altair Community Member

    Note that the default unit for date difference is in milliseconds.  So if you want it in days you will need to divide by the appropriate conversion factor.