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:
Thank you, I'll take a look at this today.
Appreciate this.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.