Hi There, I am trying to run a query/report where the Completion (end) date is before the Start date. I have been trying a few different ideas, but nothing has been successful.
Is this possible? Thanks.
Hi Toby - Welcome to the Atlassian Community!
You won't be able to do this with regular JQL. You can use an automation rule to populate a custom number field by using the diff function for dates and then do your query against that number field.
Here is the information about how to do that in Automation For Jira with Smart Values:
Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...
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
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events