Assistance with JQL query

[bronwyn.humm]

Hi, I am would like to run a query for how many issues were completed after their due date in our projects, but I am having trouble figuring out the JQL query to run. I want this data to be able to see how many issues miss the deadline so we can analyze the why.

The date range would be from 1st July 2021 until now, but moving forward, I would keep a track of it on a monthly basis.
We do work in sprints and I can get the sprint reports about any issues not completed within the sprint, which is helpful, but am specifically looking for any issues that go over their due date.

thank you :) 

[Jack Brickey · Accepted solution]

Unfortunately JQL OOTB cannot accomplish this -( JRACLOUD-20727 - Add ability to compare date fields using JQL ) which would be needed to compare due date to resolved date. There are solutions for example:

• scriptrunner addon
• create a custom field "met duedate" , true/false and use Automation to compare the dates and set the value of the field

[Carlos Garcia Navarro]

There is also this post with some more details/options: https://community.atlassian.com/t5/Jira-questions/How-do-I-calculate-between-two-dates-in-JQL/qaq-p/1122336

[bronwyn.humm]

thank you @Jack Brickey this is helpful