Jira Automation - Automatically send an email 24 hours in advance based on a date field.

Anthony Morais

I have a custom field of type Date Time Picker, called Maintenance Date. This field is nothing more than the date of a scheduled maintenance. I wanted to create an automation so that a reminder email is sent to a team 24 hours before the date selected in the custom field.

Manon Soubies-Camy

Hi @Anthony Morais and welcome to Community!

The easiest way to achieve this is to trigger an automation rule everyday and to check which issues are planned until the following day.

• Using the Scheduled trigger:

The JQL query returns all issues having Maintenance date between now and the next day at 23:59:

"Maintenance date" >= now() AND "Maintenance date" <= endOfDay(1)

You could also use the following query if you have a fixed 24h window:

"Maintenance date" >= now() AND "Maintenance date" <= 24h

• Then the email (or Slack, or Teams, or even just a Jira comment) action:

Hope this helps,

- Manon