Creating a child table based on dates in parent table

Topic Labels: Automations
922 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

Screen Shot 2022-02-04 at 11.15.24 am

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!