JQL for current month?

Angel
Contributor
June 20, 2018

Is there JQL that will just list the current month instead of the entire date?

2 answers

14 votes
Nic Brough -Adaptavist-
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.
June 20, 2018

<date field> >= startOfMonth() and <date field> <= endOfMonth()

should do the trick.  Replace <data field> with the name of the field you are reporting on.

Michelle Simmons
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 13, 2018

Hi, I could use some help with this one. I'm trying to get all the stories closed during the current month without having to manually enter the date each time I run the filter.  Is there a way to use this query for that? 

Like # people like this
Jeimi Herrera
Contributor
September 23, 2021

Thanks, @Nic Brough -Adaptavist- . It was very helpful 

Jeimi Herrera
Contributor
September 23, 2021

Hi @Michelle Simmons

This worked for me  (resolutiondate >= startOfMonth() and resolutiondate <= endOfMonth())

Like # people like this
Mirela Todorova October 13, 2024

@Jeimi Herrera @Nic Brough -Adaptavist- Thanks! 

Can it be adapted for last month as well ?

Darren Petrie October 29, 2024

Yes. startOfMonth(-1) is previous month.

1 vote
Kok Paulino
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!
September 18, 2019

If I get Angel right, she wanted to display the current month instead of the usual entire date format. That's what I need too. Any one know??

Suggest an answer

Log in or Sign up to answer