nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Jeff Boon

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?

Accepted answers

Walter Buggenhout

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!

All comments

Walter Buggenhout

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!

KAGITHALA BABU ANVESH_z1zl10

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

You can customize something like this

Thanks,

Kagithla Babu Anvesh

Jeff Boon

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.

Jeff Boon

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

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

Nic Brough -Adaptavist-

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

atl-gruland