Examining Difference Between Two Dates to Calculate Variance

[Deleted user]

Hello, I have project's contracts and due dates of work packages are defined. However, because of nature of the projects, due dates are sometimes postponed. In this situation I want to calculate difference between dates. The due date of work package according to contract is labeled as "Due Date" and real due date is labeled as "Actual Due Date". Could you help me to write correct JQL in Jira, pls?

Thank you now,

Mitra

[Mohamed Benziane]

You can't compare date in JQL, you will need to find an addon, or extract the data and make some check in an excel file

[Deleted user]

Thank you for your response, I am gonna try this you said