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

Question

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 · Answer

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 · Answer

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.