Exclude Weekends in JQL Query

[iftekhar sayyed]

Hello Team,

I have a requirement to write a JQL Query in the Automation Rule for Jira Service Mgmt.

I need to find all the requests which are approaching due dates for less than 3 days from the expected completion date.

for e.g if the completion date is  04/22/2022  so today is 04/19/2022 then the jql should return all such request information which are in progress.

Quick response is highly appreciated.

[Fabio Racobaldo _Herzum_]

Hi @iftekhar sayyed ,

unfortunately there's no a specific operator for this. you need to use startOfWeek()/endOfWeek() in your JQL in order to manually exclude specific weekend.

Hope this helps,

Fabio

[Aron Gombas _Midori_]

This question came up a couple of times in the past, see this thread for some creative ideas:

https://community.atlassian.com/t5/Jira-Core-Server-questions/Exclude-weekends-in-JQL-Query/qaq-p/1030290