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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.