Completion (end) date is BEFORE the Start date

[Toby.Springall]

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.

[John Funk]

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:

https://support.atlassian.com/jira-software-cloud/docs/use-smart-values-to-manipulate-and-format-dates/

[Toby.Springall]

Thank you, I'll take a look at this today.

Appreciate this.

Regards,