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.
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:
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event