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.



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