Hi
I have two tables: Table A that has a period_start_date and a period_end_date and Table B has a bunch of rows with a date column
In an automation that's triggered by a particular row on table A (which means I know the period_start_date and period_end_date to use) I want to find all the records from table B where the value in the date column lies between the period start and end.
The "Find records" automation seems to allow only static date values, but I need to use the period start and end dates from table A.
Any suggestions on how to do this without having to fetch all the rows from table B and then loop through in code, which feels very wasteful and slow.
Thanks in advance