Filter Issues by Due Date

I have three filters on a dashboard that list tasks due within 1d, 1w and 2w respectively; however using the JQL 'duedate <= 1d' etc means that an issue due within 1d will appear in all three filtered lists.

As issues cross filter date boundaries I want them to appear in only one of the three lists. So if an issue is due within one day I only want it to show in the filter that says duedate <=1 and not in the one that says duedate <= 1w or duedate <=2w (even though technically the condition is met in all cases so JIRA is displaying the correct logical result).

I can't quite work out the syntax required to filter issues between dates in this way and I may be asking for the impossible - anyone else managed to crack this or am I the only one with this particular use case?

Any assistance appreciated.


2 answers

1 accepted

This widget could not be displayed.

Your filter for 1w should say : duedate <=1w and duedate > 1

Your filter for 2w should say : duedate <=2w and duedate > 1w


Thanks Marc - absolutely nailed it - spot on


Does this filter include due dates for sub-tasks? 

This widget could not be displayed.

I am curious how to query if the DUE date is not filled in, we don't do this until we're ready to commit to the work but need to see the work presently in the backlog.   

duedate is EMPTY or due is EMPTY should do the trick!

Thank you William. That was just what I needed.   Bob.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

196 views 3 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you