Creating a child table based on dates in parent table

I’m trying to use automation to select rows from a parent table based on start and end dates in the parent table. How do I ask for rows where my ‘start date’ field is less than the current date and my ‘end date’ field is more than 7 days in the future.

I have both the ‘start date’ and ‘end date’ created as a date, but in automation I’m on;y given the option of selecting specific dates, not dates less than or dates greater than a value.

Hi Darrell,

When you say “current date”, I’m assuming you mean today?

If so, you should have the option to be able to get the automation to filter based on this:

If you do not have these filtering options let me know, my guess would be that your “start date” and “end date” are not date fields but string fields.

Hope this helps!

Una

1 Like