You can filter date fields to let an automation continue only when a date is before, after, or on the day you need. Date filters also work on the system fields Created at and Last modified at.
You can use date filters for many things, including:
Continuing only for tasks whose due date is within the next three days.
Continuing only for showings that are planned after today.
This page covers these field types: date, date range, Created at, and Last modified at.
Note:
Dates depend on the time zone. Each automation has its own time zone, and a date can fall on a different day in another one. Learn more in Dates and time zones in automations →.
A date filter doesn't start an automation. To start an automation on a date, use Trigger when a date field arrives →.
Who can use filters on date fields?
Automations are available on all plans: Free, Plus, and Premium. The number of automation actions per month depends on your plan. See the limits for your plan on our pricing page.
To create, edit, pause, or delete automations, you need to be a
Workspace adminof the workspace the database app is in and haveFull accessto every database the automation uses. App permissions alone aren't enough.
Add a filter on a date field
To filter a date field:
Open the database app and click the automations icon at the top right (
Create and view automations), then open an automation.Under
And if the following conditions are met, selectAdd filter.In the new row, select the field and choose the date field.
Select the option and choose how to compare (listed under Options for date fields).
Choose the date to compare with, such as
Current dateor another date field. To move it, open the dropdown next to the date, choose+Daysor-Days, and enter the number of days. For today plus three days, chooseCurrent date, then+Days, and enter3.Select
Save changes.
Options for date fields
You can choose from these options:
IsandIs notcheck whether the field is on the date you set.Is beforeandIs aftercheck whether the field is earlier or later than the date you set.Is emptyandIs not emptycheck whether a date is set.Has changedchecks whether the date was edited in this update. It only appears when the trigger isWhen a record is updated. It's available forLast modified at, but not forCreated at, because that date never changes. Learn more →
You can compare with Current date or with another date, such as a date field of the record, Created at, or Last modified at. You can't type in a fixed calendar date.
A date range field offers the same options. A filter on a date range compares the start date. To compare the end date, choose the end date of the field.
Let's look at an example
Let's say a project team wants a heads-up on tasks that are due soon and not done yet. Here's how:
Set the trigger to
When a record is updatedandAny fieldhas changedinTasks.Add the filter
WhereDue dateIs beforeCurrent date+3Days.Select
Add filterand addWhereStatusIs notDone.Select
Add action→Add a comment to the current record, then enter "Due soon: " and insert theTitlefield.Select
Create automation.
The next time someone edits a task that is due within the next three days or already overdue, you should see the comment on the task!
Date filter errors
If an automation can't be saved while you're setting it up, the editor marks the part of the filter row that's missing or invalid. Complete or remove the row, then select
Save changes.If a date filter matches a day early or late, the cause is usually the time zone. Check the automation's time zone. See Automation dates or times are off →.
If a filter doesn't match as expected, check for empty dates. An empty date never matches
Is,Is before, orIs after, but it does matchIs not. AddIs not emptyif the date must be set. See My filter doesn't match →.
Test, pause, edit, or delete a filter
To test a filter, change a test record so it matches the condition, then select the runs button at the top of the automation (
View all runs) to openRuns. AManual rundoesn't change the record, soHas changedoptions may not match.To edit a filter, open the database app, click the automations icon in the top bar, then select the automation. Change the field, option, or value, then select
Save changes.To delete a filter, select the settings button at the end of the row or group, then select
Remove.
Learn more
FAQs
What's the difference between a date filter and When a date field arrives?
What's the difference between a date filter and When a date field arrives?
When a date field arrives starts an automation on the date. A date filter checks the date after the automation has started for another reason, such as a change to the record.
Which time zone do date filters use?
Which time zone do date filters use?
Each automation has its own time zone, and date filters compare dates in that time zone. Learn more in Dates and time zones in automations →.
How do I find records created in the last week?
How do I find records created in the last week?
Filter Created at with Is after Current date - 7 Days. The date is relative, so it moves with each run.
Can I check the time of day, not only the date?
Can I check the time of day, not only the date?
Date filters compare the day when you use Current date. If you compare with another date that has a time, the time counts too.
Where can I find all automation filter options?
Where can I find all automation filter options?
In Automation filters →. It explains how to combine rows and groups and links to the options for each field type.
Are you a developer using the Tape API for automations?
Are you a developer using the Tape API for automations?
The automation API has its own documentation for developers. Full reference: Filters in the developer docs →
Still have questions? Find answers and get help from community experts in the Tape community →
