Chose latest date between two column

Hello dears,
is there a way in knime to scan two dates column, and then chose the latest.
i thought of choosing the extract date & time fields then comparing then retransform to date. but is there a faster way?

Hi @mh_elhassan

I’m not currently in front of a computer and answering from a mobile phone but as far as I remember, this can be easily achieve using a -Rule Engine- node with the following rules:

$date1$ > $date2$ => $date1$
TRUE => $date2$

The dates need to be both of date type. It will not work if they are of type string.

Hope this helps.

Best
Ael

5 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.