🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

How to calculate Difference between time intervals?

pantangi_shekar

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

Thanks in advance.

Best,

Raj.

Find more posts tagged with

AI Studio

Accepted answers

Thomas_Ott

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

All comments

Thomas_Ott

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

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.