Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to use StartofYear(), EndofYear() in JIRA JQL?

Edited

Hi community, I am trying to churn a report using JQL filter that displayed monthly ticket assigned to particular person in a year.

I am really confused regarding the usage of StartofYear() and EndofYear()

Since we only started using JIRA in November, below query should return data for the month of November (11M) but I am not sure why, the query below is not returning any data...

after startofyear("+11M") before endofyear("+11M")

From what I understand, the above query should return data from Starting of November to end of November right?

2 answers

1 accepted

0 votes
Answer accepted

Hi @Jeff Boon,

I would suggest 2 small adjustments. To start from November, just add 10 months instead of 11 and leave out the "+" as this is a reserved character. 

> startOfYear(10M) and < endOfYear(10M)

For now, you can of course just leave out the < endOfYear(10M) part, as we're not there yet.

Hope this helps!

Ah yes, I think I misunderstood the meaning of 11M, I thought the 11M is meaning November but instead it is supposed to add 11 Months. Thank you for your answers.

Hi @Walter Buggenhout _ACA IT_ , Any reason why the query below also returned November data?

after startofyear(9M) before endofyear(9M)

Because startofyear and endofyear do what they say - they give you the start and end of the year. not a month within a year.

I suspect you should be using "after startofmonth(9M) before endofmonth(9M)" if you only want to see data for a particular month

0 votes

Hi @Jeff Boon 

 

If you want to know the tickets crated in November/current this month use this below.

created >= 2021-11-01 AND created <= 2021-11-30 order by created DESC

The above will display all the issues created from 1st November to 30th of this November.

Another way

createdDate >= startOfMonth() and createdDate <= endOfMonth()

if you are completely new to JQL please shift to BASIC while searching the issues  please follow the below

Menu -> Filters -> Advanced issues search

image.png

You can customize something like this

image.png

 

Thanks,

Kagithla Babu Anvesh

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

378 views 1 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you