Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Date functions in AQL is not working

Bhupesh Garg
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 1, 2024

 

I'm having some issues with the month & year functions.

1. When using 'startofYear()' - it's not accepting any 'y' values but weird that only taking 'm' values.

2.  When using 'startofMonth()' - it's returning all the objects with whatever values we put in for operator '<'. And, only current month's objects if we put in operator '>'.Assets2.JPGAssets1.JPG

2 answers

0 votes
Rilwan Ahmed
Community Champion
July 1, 2024

Hi @Bhupesh Garg ,

Welcome to the community !!

The right syntax is described in https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfYear--

If you can provide your requirement, I can try to get the JQL for that. 

0 votes
Halina Cudakiewicz_Deviniti_
Atlassian Partner
July 1, 2024

Hi @Bhupesh Garg 

This might be due to incorrect AQL usage or a bug. To troubleshoot, double-check your AQL syntax, ensure your JIRA instance is up-to-date, and consider consulting Atlassian support.

Suggest an answer

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

Atlassian Community Events