Comparing date, equal to or less than

Hello,

Is it possible to compare dates from two tables and filtering on them?

For example table A has the date input by the user:
30/03/2023

Table B has all of the user data, thousands of lines:
01/02/2021
04/06/2022
04/05/2023

I want to take that first date and say "keep any dates, that are equal to or less than this date.
So from table B, i should only keep the top two dates. It wouldn’t keep the bottom one as that is ahead of our user input date.

Many thanks,

Hi @ThomasRobsonPG

How about the DateTimeBasedRowFilterNode?

gr. Hans

3 Likes

Hi @ThomasRobsonPG

Complementary to @HansS’s answer, this is possible as well with the -Rule-based Row Filter- and -Rule-based Splitter- nodes.
The rules to use would be for instance as follows:

$date 1$ > $date 2$ => TRUE
TRUE => FALSE

which means if $date 1$ is later than $date 2$ then filter in the row, otherwise filter it out.

Hope it helps.

Best
Ael

3 Likes

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