check if date is between dates

[ScottF]

In that case, have you considered a workflow like this one?

Comparing dates from a reference table

Hi @KunalB86 - I had a very similar question come up from a student in an L2-DS course a few weeks back. The key was to use flow variables for Start and End dates with a Date&Time-based Row Filter node. Take a look at question 1 in the attached workflow and see if it helps you. [2020-10-06 12_36_54-KNIME Analytics Platform] LoopingOverDateRangesExample.knwf (61.9 KB)