Skip to main content

Filter automations by date fields

Let an automation continue only when a date is before, after, or on the day you need. Works for date fields, date ranges, Created at, and Last modified at.

Written by Leo

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.

An automation in the editor. The trigger is When a record is updated and any field has changed in Tasks. The filter reads Where Due date Is before Current date + 3 Days, And Status Is not Done. The action adds the comment Due soon: @Task / Title to the current record.

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:

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 admin of the workspace the database app is in and have Full access to every database the automation uses. App permissions alone aren't enough.

Add a filter on a date field

To filter a date field:

  1. Open the database app and click the automations icon at the top right (Create and view automations), then open an automation.

  2. Under And if the following conditions are met, select Add filter.

  3. In the new row, select the field and choose the date field.

  4. Select the option and choose how to compare (listed under Options for date fields).

  5. Choose the date to compare with, such as Current date or another date field. To move it, open the dropdown next to the date, choose + Days or - Days, and enter the number of days. For today plus three days, choose Current date, then + Days, and enter 3.

  6. Select Save changes.

In a new automation for Tasks, selecting Add filter, choosing Due date and Is before with Current date, opening the dropdown next to the date, choosing + Days, and entering 3

Options for date fields

You can choose from these options:

  • Is and Is not check whether the field is on the date you set.

  • Is before and Is after check whether the field is earlier or later than the date you set.

  • Is empty and Is not empty check whether a date is set.

  • Has changed checks whether the date was edited in this update. It only appears when the trigger is When a record is updated. It's available for Last modified at, but not for Created at, because that date never changes. Learn more →

A filter on Due date in a new Tasks automation with the trigger When a record is updated, with the options Has changed, Is, Is not, Is before, Is after, Is empty, and Is not empty

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:

  1. Set the trigger to When a record is updated and Any field has changed in Tasks.

  2. Add the filter Where Due date Is before Current date + 3 Days.

  3. Select Add filter and add Where Status Is not Done.

  4. Select Add action → Add a comment to the current record, then enter "Due soon: " and insert the Title field.

  5. 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, or Is after, but it does match Is not. Add Is not empty if 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 open Runs. A Manual run doesn't change the record, so Has changed options 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?

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?

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?

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?

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?

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?

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 →

Did this answer your question?