Date time filtering, need the "false" items

[bmansoor]

Hi

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.

[elsamuel]

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:

[iCFO]

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

[bmansoor]

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.