Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL Query for tommorow tasks- exclude weekends

Juraj Javorsky
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 2, 2023

Hello, i have this query in JQL, that returns all tasks where start date or due date (all custom fields) is tommorow.

 


project = "ACY" AND type = "Design" AND cf[10015] = endOfDay("+1") OR cf[10036] = endOfDay("+1")


 

I want to edit it, so it will display tasks for Monday on Friday (to just exclude weekends). Is there any way to achieve this?

1 answer

0 votes
Manoj Gangwar
Community Champion
June 2, 2023

Hi @Juraj Javorsky , 

 

this is a recurring question. Right now there is not a specific way to do that. You need to use startOfWeek()/endOfWeek() in your JQL in order to manually exclude specific weekend. 

Juraj Javorsky
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 2, 2023

So i need to create a specific query for "fridays", is that right? :)

Manoj Gangwar
Community Champion
June 2, 2023

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events