Run an automation that triggers at the DueDate but at a specific time

[Davide Orbitello]

Hello!

I am trying to create a rule for a project that should send an email to the reporter at the DueDate chosen by him but at a time that I want to default.

For instance, the reporter will choose a date like tomorrow but I want the email that will be sent by automation will be sent at 5 pm.

Is this possible?

[Kian Stack Mumo Systems]

Yes,

All you need to do is run a scheduled rule each day when you want to send the email.

Then use the JQL "duedate = endOfDay()" inside of the Scheduled trigger to pull issues that are due today.

[Marcus Jones]

Hey David!

There may be anoter/better way to do this, but I have similar requirements in a couple projects and I solved using the below automation.

You can create a scheduled automation that runs every evening at 5pm. You can use a JQL query to pull relevant tickets like only ones that are not closed and/or don't have a resolution. Then create a variable. I call mine {{DueDateCompare}} = {{now.diff(issue.duedate).days}}. 

Then create an If block and set your requirements like: Status != Closed and {{DueDateCompare}} = 0. 

You can then craft your email gets sent based on the above section results.