Completion (end) date is BEFORE the Start date

Toby.Springall February 9, 2021

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.

1 answer

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 10, 2021

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 February 10, 2021

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

Appreciate this.

Regards,

Like John Funk likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events