Join or Keep ON date columns

[#1]

Is it possible to do a Left Join or a Left Keep ON a table1.datecolumn > table2.datecolumn?

I have users who joined a pilot program, and I only need to load sales that they've made after the pilot program started. I have the user's ID for the join/keep and would also like to join based on the sale_date >= pilot_start_date (different for each user).

I can create an indicator, but then the user would need to filter based on that indicator column every time, which I don't want to have.

[maxgro · Accepted solution]

if you don't have a lot of rows you can join the tables with userid and add the 2 fields

table1.datecolumn, table2.datecolumn

then with a resident load filter the rows where table1.datecolumn > table2.datecolumn

[#3]

Great, that works. Thanks!