Find Overdue Tickets

[Aaron H.]

I want to create a column that is named "Overdue?", it should measure the the "Due Date" and the resolved date. I was trying to compare the solve date by the due date but that is not working. I'm also looking for all tickets in all status.

Solve date | Due date | Overdue?

10/23.         | 10/10        | Yes

[Trudy Claspill]

Hello @Aaron H. 

Welcome to the Atlassian community.

What tools are you trying to use (within Jira) to accomplish this?

Are you trying to do this using only the View All Issue page? Natively Jira does not support comparing two date fields to each other, so that will not work.

Have you created a new field called "Overdue", which you then want to set based on comparing the dates? You could use an Automation Rule to review the issues, compare the dates and set the Overdue field appropriately.

There are other options that could be available if you have certain third party apps or are willing to acquire them.