Filter out weekends

NM_kqn2mh

 

I'm trying to filter out issues that has exceeded the set due date, the challenge while using the below JQL is it is also counting the weekends. can someone help me with a JQL that would count only the business days?

 

Project = X AND issuetype = Y AND priority = High AND status not in (Complete, Incomplete) AND "High Transition Date" <= "-24d"

Hariharan Iyer_f6fx5m

Hi NM,

 

This is not possible out of the box in JQL. However there are some 3rd party plugins that can help you do this - e.g. JMCF.

Another option is to use a heuristic depending on when you're running this query. E.g. if you run it every week on Monday, then you know that 24 days prior would include 4 weekends, so you could change your condition to 

"High Transition Date" <= "-32d"

Things will get a bit hairy if you run this on Friday though, and also this doesn't take into account non-weekend holidays.

 

Thanks,

Hariharan