Using Business Days Instead of Calendar Days in JQL Query

Beau Grantham 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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