Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Creating a child table based on dates in parent table

Topic Labels: Automations
390 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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!

Una