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.
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.