Date time filtering, need the "false" items


I have a table with dates, correctly type cast to dates. I’d like to filter rows based a column such that I see dates that are outside the range, e.g. outside 01-11-2022 and 31/01/2023. I can’t work out how to do that using the tools available.

  • Tried using the date&time based row filter, but it only allows me to see the items within the range, not the negative.

  • with the rule-based row filter I can’t work out a function to cast a string or variable to a date, like a date() or similar.

I’m new to KNIME so this might be straightforward, but can’t see an obvious way to do this.

Help would be super appreciated.

Welcome to the forum, @bmansoor.

A splitter node will allow you to keep all records.

If I start with a column of dates ranging from 2021-06-02 (this is yyyy-mm-dd) to 2023-06-02:

I can use a Rule-Based Row Splitter node to grab, for example, all dates except those in January 2023:

Heere are the outputs:


The Reference Row Filter is always a nice trick to use to find remaining rows as well.

1 Like

Thanks, this is exactly what I needed and works perfectly.

If you have any insight into why the date needs to be in quotes, would love to understand that too. Without context, I would have assumed that treated the contents within the quotes as a string rather than a date.

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