Calculating time difference in days between two dates

Dear Rapidminer Community,
I am struggling on a very simple problem. I am trying to calculate the difference in days between two dates. I know there is a function called "date_diff" in generate attributes but I dont know how to enter a correct date.
No I don't have the two dates in seperate columns, I only have the date in the above format in one column and I know the end date (24.12.2016).
E.g. I want to calculate the date difference between 25.08.2016 and 24.12.2016 (German date format). How do I enter a correct format like this in rapidminer in the date_diff function?
Best regards
Felix
Best Answer
-
Hi @felix_w,
it works like that:
date_diff(dateAttribute,date_parse_custom("24.12.2016","dd.MM.yyyy"))
note that you can get the current timestamp with date_now().
Best,
Martin
2
Answers
-
Hi @felix_w,
it works like that:
date_diff(dateAttribute,date_parse_custom("24.12.2016","dd.MM.yyyy"))
note that you can get the current timestamp with date_now().
Best,
Martin
2 -
And just remember that date_diff function will return results in milliseconds so if you want to convert to another time unit (like days) you'll need to divide the result by the appropriate number.
2 -
Thank you Martin! Having different date formats all around the world really sucks ^^
Best regards
Felix
1 -
Hi @felix_w,
right. But as long as you don't have DD-MM-YYYY and MM-DD-YYYY in ONE document/example set everything is good. And yes, this exists
Best,
Martin
1