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

Tracking changed due dates

Is there a formula to filter issues in which the due date has been changed?

1 answer

0 votes
Stephen Wright Community Leader Oct 02, 2019


Not in JQL - there are some history searches but only for a very small group of fields, of which due date is not one of them.

You could pull the issue history for issues via REST API and get the information from there if required - see more details on the REST API by clicking here.

If I was to do this with JQL, this is what I would do:

  • Create a dashboard for due dates with multiple filtered lists - eg. due in 1 month, 2 months, 3 months
  • Look for anomalies in these lists when checked (eg. each day)
  • Provide a list of all issues which meet these three filters that were updated since the last check (eg. in last 24 hours)

^ It's not an ideal solution, but this would allow me to consider issues which are moving between lists and updated within a 24 hour period. This remains a real-time option, aside from just exporting a copy of the data once a day and doing a VLOOKUP or similar.


Thank you for your help.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Keep your team in the loop with Team @mentions in Jira Software!

Hi everyone! My name is Jenny, a Product Manager at Atlassian. After launching Team @mentions in Confluence, we heard a lot of positive feedback from customers that they love how easy it is to @men...

555 views 6 18
Read article

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