Notifications for due date account for weekend

Question

Hi there,

I have a couple of simple automations setup to send an email notification if a task/issue's due date is today or 1 week away.

I would like to set another up for if the due date is 3 days away. However, for both the 3 day and 1 week ones I would like it to take into account business days only.

My current automations are using a very simple code that does the job, which is:

Today notification: due <= 1d

1 Week notification: due <= 1w

Any help would be much appreciated.

Phill Fox · Answer

Hi @Sorren Day Would you like to try this JQL and see if this works for you? project in () and ((duedate <3d and duedate endOfWeek(-2d))) The first part restricts the query to only this projects that you want to test. This is a great way of restricting down your test scope. Then we have two similar conditions. Let us look at the first one. (duedate <3d and duedate endOfWeek(-2d) Here we push out the 3days to 5 days to allow for the weekend and check that the due date is after Friday. Let me know if this works for you or if not what challenges you experience. Thanks Phill

Sorren Day · Answer

Hi @Rilwan Ahmed

That was my understanding. I'm hoping the solution you linked to from @Phill Fox can be tweaked to achieve my requirement? I am just unsure how to do that. I need the code to look at the due date rather than the status, but when I try making that change it doesn't work.

Thanks

Rilwan Ahmed · Answer

Hi @Sorren Day ,

In native jira, there is no way to exclude Saturday and Sunday in the JQL search.