JQL Query for tommorow tasks- exclude weekends

Question

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?

Manoj Kumar Gangwar · Answer

Nope, please follow the below thread.

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

Juraj Javorsky · Answer

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

Manoj Kumar Gangwar · Answer

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.