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

I need compare two date fied (Date Resolve vs End Date)

Cristian Peque October 27, 2022

Hi, somebody can help to create a filter where show me all issues with date resolve are > End Date?
Example: project = OCLTP AND "Date Completed" > "End Date" ORDER BY "End Date" ASC, updated DESC

But show me an error. I readed that is it not possible, but other options?

2 answers

1 accepted

0 votes
Answer accepted
mauricio.groth
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 28, 2022

Hi @Cristian Peque 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all your issues that the Date completed is bigger than the end date.

issue in dateCompare(“'Date Completed' > 'End Date'”) and project = OCLTP ORDER BY "End Date" ASC, updated DESC

Check out the documentation for more examples. 

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

Cristian Peque October 28, 2022

Hoo Thanks. Maybe this works for me. I will send to our jira Admin. thanks!

1 vote
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 27, 2022

Hello @Cristian Peque 

Jira does not natively allow you to compare two issue fields as part of your filter criteria.

If you are open to using a third party app, you could do this with Adaptavist Scriptrunner

 https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, ace, atlassian community event, donation, girls who code, women in tech, malala fund, plan international, kudos, community badge, badge, atlassian badge, International Women’s month, International Women’s Day, women's month, women's day

10 for Change at Atlassian Community Events

Show up and give back by attending an Atlassian Community Event: we’ll donate $10 for every event attendee in March!

Join an Atlassian Community Event!
AUG Leaders

Upcoming Jira Events