Filter table for records 90 days or longer ago?

[Mirri]

Hi All,

I have a table with a datetime column, which i have applied a ‘String to Date&Time’ node.

I would now like to filter to only show records which are older than 90 days before today.

Unfortunately, i can figure out how to do this via any of the filtering nodes.

Any help appreciated!

Regards

[rd2575691]

Hello,

Does this help?
90_days_filter.knwf (21.7 KB)

[ipazin]

Hello @Mirri,

there is also Date&Time-based Row Filter node which you can configure to take current execution date and input -90d as duration.

Br,
Ivan

[bruno29a]

Nice @ipazin , I was not aware of this node, this is cool, no need to do date manipulation separately and filter separately, all in one node, very nice indeed.