Skip to main content

Trigger when a date field arrives

Start an automation on a date in a record, such as a due date, on the day itself or days, weeks, or months before or after, at a time you choose.

Written by Leo

When a date field arrives is a trigger that starts an automation when a date in a record is reached, on the day itself or a number of days, weeks, or months before or after (the trigger decides when an automation starts, and the filter decides whether it continues). It's meant to help you remind people of deadlines without checking dates by hand.

You can use this trigger for many things, including:

  • Reminding the assignee three days before a task's due date.

  • Emailing a tenant a week before a lease ends.

Creating an automation in the Expenses database app: clicking the automations icon, New automation, and When a date field arrives. The trigger reads On day when Date arrives at 8:00 AM in Expenses, with an empty filter row below

Note:

  • It runs once for every record whose date arrives. Each record keeps its own date, so one automation covers all records in the database app.

  • You choose the time of day. The automation runs at the time you set, for example 8:00 AM.

  • A manual run doesn't wait for the date. It runs the automation right away on the records you choose.

  • A month counts as 30 days. Months before and Months after add or subtract 30 days per month, not calendar months.

  • Records that are still being created don't count. A record starts the automation only once it has been created.

Who can use the When a date field arrives trigger?

  • Automations are available on the Free, Plus, and Premium plans. 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, run, or delete automations, you need to be a Workspace admin in the workspace the database app belongs to. Only workspace admins see the automations icon in a database app.

Set up the When a date field arrives trigger

To set up the trigger:

  1. Open the database app on desktop or web and click the automations icon in the top bar (tooltip Create and view automations).

  2. Select New automation.

  3. Select When a date field arrives from the list of events.

  4. Select the parts of the trigger to choose when it runs, the date to watch, and the time of day. Learn more about the date and the time below →

  5. Add a filter if the automation should only continue for certain values. Learn more about filters below →

  6. Select Add action and choose what should happen.

  7. Select Create automation.

The trigger On day when Date arrives at 8:00 AM in Expenses in the automation editor

Choose the date and the time

The trigger reads like a sentence: On day when Date arrives at 8:00 AM in {app}. Select each part to change it:

  • On day sets when the automation runs. Choose On day to run on the date itself, or Days before, Days after, Weeks before, Weeks after, Months before, or Months after. Then pick the number from the list, for example 3 days. You can choose 1 to 30 days, 1 to 10 weeks, or 1 to 12 months. The trigger then reads, for example, 3 days before.

  • Date (the field name) sets the date to watch. You can watch:

  • a date field,

  • the start date or the end date of a date range field,

  • a calculation field that results in a date,

  • the date the record was created (Created at),

  • the date the record was last changed (Last modified at).

  • 8:00 AM sets the time of day. You can choose any time in 15-minute steps, from 12:00 AM to 11:45 PM.

Opening On day in the trigger, pointing to Days before, and choosing 2 days, so the trigger reads 2 days before Due date arrives at 8:00 AM in Tasks

Tip: For a reminder, use a few days before the date. To follow up on something overdue, use a few days after it.

Filter the When a date field arrives trigger

The filter decides whether the automation continues after it's been triggered. Under And if the following conditions are met, select Add filter and build a condition, for example Status Is not Done, so people aren't reminded of finished tasks. Learn more about filters →

Let's look at an example

Let's say you want to remind the team three days before a task is due. Here's how:

  1. Set the trigger to When a date field arrives with the Due date field, Days before → 3 days, at 8:00 AM, in Tasks.

  2. Add the filter Where Status Is not Done.

  3. Select Add action → Add comment, then enter "This task is due in three days: " and insert the Title field.

  4. Select Create automation.

Three days before each due date at 8:00 AM, you should see the comment on the task!

Dates and time zones

The automation runs at the time you set. Each automation has its own time zone. It starts with the time zone of the person who creates the automation. To change it, hover over the automation's name in the editor and select Time zone above it. Learn more about dates and time zones →

When a date field arrives errors

  • If the date field is empty for a record, the automation doesn't run for that record. There's no error.

  • If you change the date of a record later, Tape plans the run for the new date instead. If the new date is already in the past, the automation doesn't run for it.

  • If the status below the automation's name shows Broken in red, part of the automation doesn't fit the trigger, often an action that needs a current record. The part that doesn't fit is shown in red. While the automation is Broken, it doesn't run and you can't start a manual run. Tape then shows Trigger runs manually not possible because of broken automation.

  • If a run fails, you can see each step and its message in the automation's runs. To see the runs of an automation, click ▷ next to Manual run at the top right of the editor (tooltip View all runs), or press cmd/ctrl + 1. The Runs panel lists the runs of the last 30 days. Select a run to see each step and its message. To see the runs of all automations, select Runs in the sidebar of the Automation Center.

  • Lots of automation activity in a short time can delay automations across your organization. The delay is temporary. Tape checks the load again shortly and runs waiting automations automatically. Learn more about limits and throttling →

Test, pause, edit, or delete an automation with this trigger

  • Manual run runs the automation once on the records you choose, no matter what their date is. It has real effects, so the comment from the example is posted. Learn more about testing →

  • New automations you create in the editor are Active right away. To pause one, select Active below the automation's name, then select Save changes. The status switches to Paused. Select it again and save to turn the automation back on.

  • To edit an automation, open the database app, click the automations icon in the top bar (tooltip Create and view automations), then select the automation. Select Save changes when you're done.

  • To delete an automation, open it and click ••• at the top right, then select Delete. Confirm with Delete. You can also click ••• on the automation's card in the list of automations, then select Delete. Deleting can't be undone.

  • To switch to another trigger, hover over the trigger and click ••• to the right of it, then select Turn into and choose a trigger. The filter and the actions stay. If an action or a filter condition doesn't fit the new trigger, for example Update record after switching to a schedule, or Has changed after switching away from When a record is updated, the status below the automation's name turns red and shows Broken until you change or remove it.

Learn more

FAQs

How do I send a reminder before a deadline?

Choose the deadline field, choose Days before with a number of days, and pick the time of day. Then add an action such as Add comment or Send email.

Can I run the automation on the date itself?

Yes! Choose On day.

Can I run it again every week or month?

No, this trigger runs once per date and record. For a report that repeats, use Trigger on a schedule →.

Can I use a date range?

Yes! Choose a date range field, then choose whether the start date or the end date counts.

Can I run it at a certain time of day?

Yes! Select the time in the trigger, in 15-minute steps.

Are there other triggers I can use?

Yes! An automation can start when a record is created, updated, or deleted, when a comment is added, when a date arrives, on a schedule, and more. See every trigger in Automation triggers →

Are you a developer using the Tape API for automations?

The automation API has its own documentation for developers. Full reference: Triggers in the developer docs →

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?