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 · Accepted solution]

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

[Ashly Montaño]

Wow really thank you very much!
I needed this information 

[Anthony Morais]

@Manon Soubies-Camy Thanks for the quick response.
I already tested it and it worked, thank you very much.

[Manon Soubies-Camy]

Glad it helped :)