Forums

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

Using Business Days Instead of Calendar Days in JQL Query

Beau Grantham
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!
December 20, 2021

" project = FTE AND summary ~ "\"IAW log review\"" AND issuetype = Task AND status = "In Progress" AND updated <= -3d "

For this JQL filter my team and I are trying to show issues that have been updated to in progress status more than 3 days ago. However, we do not want weekends and holidays included. Is there a simple solution that can look at just business days instead of calendar days?

1 answer

1 accepted

1 vote
Answer accepted
Mark Segall
Community Champion
December 20, 2021

Hi Beau,

Welcome to the community.  There's a similar question at the link below that may help:

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

Dan Breyen
Community Champion
April 6, 2023

@Beau Grantham did that other article answer your question?  If so, could you mark this as answered? Thanks,

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events