Relative Due Date Triggers

The Date has expired trigger runs relative to the date of each record. Use it for the Due date field or another Date field of the database.

Set the trigger at expiration or a specified number of minutes, hours, days, or weeks before or after expiration.

Create a Relative Date Automation

1. Open the Automations list of the database. Read Open Automations.
2. Select Create Automation > Event Automation.
3. In When, select Date has expired.
4. Under Date field, select Due date (default) or another Date field of the database.
5. Under When to trigger, select at expiration, before expiration, or after expiration.
6. For a before or after trigger, enter an offset and select minutes, hours, days, or weeks.
7. To exclude completed records, select Restrict to incomplete records.
8. Add one or more actions in Then.
9. Select Create Automation.

Examples

• One day before the due date: Send a reminder email to the assignee.
• At expiration: Set the Tags field to Due today.
• Three days after the due date: Add a manager to the Assignee field and set the Tags field to Escalated.
• One week before a custom Renewal date: Copy the record to a follow-up workspace.

Behavior

• Blue schedules the automation separately for each record and selected date field.
• If the date changes before the scheduled time, Blue replaces the pending time with the new time.
• Records without a value in the selected date field do not start the automation.
• Completed records remain eligible unless you select Restrict to incomplete records.
• For an all-day date, expiration occurs after the due day. Before-expiration offsets use the end of the due day.