JQL for current month?

Angel June 20, 2018

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

2 answers

11 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 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 September 23, 2021

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

Jeimi Herrera September 23, 2021

Hi @Michelle Simmons

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

Like # people like this
0 votes
Kok Paulino 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