Correct way to get Quarter values

Urmo
Contributor
September 27, 2024

Hi

I try get answers from chatgpt but seems to be that he did not have it. So how i should write JQL to get nest year first Quarter values from Due Date field?

And another question is how should JQL be to get only values form Due Date field with JQL:

Due Date >= startOfYear(6M) AND Due Date <= startOfYear("9M")

I Know that there is possible to use endOfMonth value but when i like this filter works this year but does not show next year Q3 values?

 

Urmo

1 comment

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 27, 2024

Hi @Urmo 

With the JQL startOfYear() function, you may increment the value to match your quarters. 

For example this query would find issues due during the third quarter of this year.  Please note well the use of >= and < to be within the range.

project = yourProjectName
AND duedate >= startOfYear("+6M")
AND duedate < startOfYear("+9M")

Please look at this documentation to learn more: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfYear--

Kind regards,
Bill

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events