How do I pull a report on the original Due date

[mark williams]

I want to run a report highlighting where projects due dates slip. So showing the  epic, the original due date and the current due date. I don't see an easy way via filters to pull this data, and can only run reports against the current due date. 

[John Funk]

Hi Mark - Welcome to the Atlassian Community!

One way is to create a custom data field for Original Due Date and the populate it when you create the ticket. You can actually automate that using Automation For Jira - that way the field can be hidden and still get populated. 

[Jack Brickey]

Hi Mark, welcome to the Community.

So you really can't filter on a duedate changing directly. Here is how I approach this...

Never change Due Date - consider implementing what I refer to as plan-forecast-actual approach. The Plan should never change as that was your plan even if your plan was flawed. The Forecast can change as needed to reflect current view. Actual is when the issue is actually resolved. To implement you would only really need to add one custom date - Forecast. Use Due Date as plan and the actual is = resolutiondate.

Now to be able to create a report, unfortunately, you would need to employ excel or an addon. 

[Bill Sheboy]

Hi @mark williams -- Welcome to the Atlassian Community!

Once you have the fields Jack suggests, you could use an automation rule (as John suggests) to detect a change with a date slip and then alert you with an email.

Best regards,

Bill