How to find the task with the particular duedate

Question

Hello everyone!

I am trying to find issues/tasks such that the difference between the established due date and createdDate was no more than 2 or 3 days. Tested stuff like this:

due = createdDate + 2d

Unfortunately, it is not working. Could you help me with that?

Thanks a lot.

Ollie Guan · Accepted Answer

Hi @Nadya Domracheva ,

pls refer to this post

https://community.atlassian.com/t5/Jira-questions/JQL-to-show-issues-that-were-submitted-with-a-Duedate-2-days-or/qaq-p/622056

Bill Sheboy · Accepted Answer

Hi @Nadya Domracheva -- Welcome to the Atlassian Community!

You cannot compare different issue fields with out-of-the-box Jira Cloud features.  Specifically, JQL is not a SQL and so does not have such features.

Some possible work-arounds to solve this use case depend upon how often you want to do this and how much money/effort you want to spend/invest.  For example:

* need this one time* Try exporting your issues to a spreadsheet and perform the data comparison there

* need this often, and got lots of money to spend* Take a look at the Atlassian Marketplace for JQL or reporting addons which support comparing fields and/or performing math on them to create calculated fields

* need this often, and do not want to purchase an addon app, and willing to learn about automation rules* Use an automation rule to detect and report on this condition.  This could be triggered as a scheduled rule (e.g. every day) or whenever the fields change, storing the difference in a new custom field.  That custom field could then be searched using the built-in JQL.

Kind regards,
Bill