Forums

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

JQL to get all the issues created in 0-3 days of month

Gajanan Sasane
Contributor
March 31, 2021

I need JQL to get all the issues which was created in first 0 to 3 days of the month.

1 answer

1 accepted

2 votes
Answer accepted
Jack Brickey
Community Champion
March 31, 2021

Please see if this gives you the desired results 

createdDate >= startOfMonth() AND createdDate <= startOfMonth(3d)

Gajanan Sasane
Contributor
March 31, 2021

Hi @Jack Brickey :

Thanks for the answer.
again I have a query, how would I get the issues which is created 4 to 7 days of the month.

Jack Brickey
Community Champion
March 31, 2021

Please explain what you mean by 4 to 7. Do you mean, for example March 4th - 7th? If so...

createdDate >= startOfMonth(4d) AND createdDate <= startOfMonth(7d)

hopefully you see the concept here. I recommend you playing with this to get a feel for the logic/syntax. Also, you might want to reference this article - what-is-advanced-searching-in-jira-cloud 

Suggest an answer

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

Atlassian Community Events