Need to include 5 business days and exclude weekends in Jquery

[kotha Eswar rao]

As of now for the below mentioned J query I have mentioned tickets not updated for  5 days , Is it possible to update the below logic to 5 business days instead of 5 days, could you please share the updated  J Query

Need to include 5 business days and exclude weekends for the below query

updatedDate<= "-5d" AND type in (Incident, "Service Request") AND status="Waiting for customer"

[Albert Manuel · Accepted solution]

Hi,

As far as i know, Jira doesn't know about weekends, a workaround i did in the past was to count days from the beginning (Monday) and exclude the last two. You can achieve this by using the JQL: startofWeek(-2d).