Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Filtering issues where "due date" > "target end"

Hi, I would like to filter issues where "due date" is higher than "target end" in order to see which issues have been completed later than planned initially.

I already have included in my projects both columns.

Can you explain me how to do it please? 


2 answers

2 accepted

2 votes
Answer accepted

Hi Giampiero,

I can confirm with ScriptRunner for Jira Cloud you can use the Date Compare enhanced search function which is documented here and this page provides examples of how this function works.

Alternatively when on the Enhanced Search page you can click the + button at the end of the search bar to bring up a dilog that will give you a form that you can complete to define the query that you require.

Finally, I can confirm once the filter has been created you can save this filter and share it to reference in items such as Agile boards and the knowledge base article located here explains how to do this.

I hope this information helps.



Thanks Kristian! This information helped a lot. Best

0 votes
Answer accepted
Jack Community Leader Jun 24, 2021

JQL does not allow for date compare. You will need an addon app, e.g. Scriptrunner 

Thanks for the information @Jack . Do you know how to prepare this specific quick filter with ScriptRunner Enhanced Search?

Jack Community Leader Jun 24, 2021

I don’t. I have not used Scriptrunner for many years. However there are posts in the community on this so a bit of searching should produce results.

Suggest an answer

Log in or Sign up to answer

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you