Exclude Saturday and Sunday from a range of dates in JQL

I have this query

project = "xyz" AND due > startOfDay() AND due = startOfDay(3d)

What this does is , it gives me the issues where there are exactly 3 days remaining until the due date from today.

i.e if I have a ticket which has a due date of 10th July 2023 and today is 7th July 2023, the issue should show up.

Now from the 7th July to 10th July , there are weekends 8th and 9th July ( Sat and Sun).

Currently what the JQL is giving is including the weekends.

I want the JQL to exclude it.

Expected result: If the due date was on 10th July, it should give me the result when today was 5th of July.

How do I achieve this with JQL?

1 answer

0 votes

I think you would be able to find something creative here in a similar topic

Hope it helps!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.