How to find the task with the particular duedate

[Nadya Domracheva]

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.

[Bill Sheboy · Accepted solution]

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

[Nadya Domracheva]

Hi Bill, thank you so much for your suggestions. I think I'll realize the last one about the automation notification. Thanks a lot

[Ollie Guan · Accepted solution]

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

[Nadya Domracheva]

Thank you!