Compare the date and number of days between two dates

I have an Excel file in the following example:
1- I want to check the date of the first and last communication based on two fields of a table and display it for me in one column. It means to record the first and last date based on the two fields name and number.
2- Calculate and display the number of days between two dates.
My sample file

hi @alex1368
see if this approach accomplishes your expectations.


KNIME_day-diff-MM.knwf (91.1 KB)
rgds.

1 Like

"Hello @alex1368,

you can design a workflow similar to the attached and configure it with the help of the reference also attached

Screenshot 2024-02-12 145234

Screenshot 2024-02-12 145654

2 Likes

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