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.
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.
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
Hope this helps,