Filter to show issues that were created less than 14 days before due date

[Ari Robinson]

I am trying to create a filter that will show issues created with fewer than 14 days before the due date for the issue. Is this possible and can you point me in the right direction?

[Bill Sheboy]

Hi @Ari Robinson -- Welcome to the Atlassian Community!

That is not possible with the built-in features of JQL for filters: it cannot compare 2 issue fields in a query.

As workarounds, you could:

• investigate marketplace apps which add features to JQL / Jira,
• create a filter subscription for issues created daily and manually monitor the due date values, or
• learn about automation rules which could detect the condition (and perhaps add an indicator which could be searched with built-in JQL).

Kind regards,
Bill