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; } } }

Is it possible to JQL search the last day of the previous month?

Donna Hulme

I am trying to get a count of items in an open status on the last day of previous month.

Right now I am using on "2019/01/31" but I was wondering if there was a way to pull the last day of last month into a filter so the date doesn't have to be edited each month? I tried using"lastBusinessDayOfMonth" but I can't seem to get it to work.

Thanks!

Accepted answers

Christos Moysiadis

Hi @Donna Hulme,

Try this maybe : created > endOfMonth(-1) and created <= endOfMonth(-1)

Best regards

------------ EDIT -------------

Or only : created = endOfMonth(-1)

Jack Brickey

I don't know about "previous" month but wondering if you can use something like this...

status was not done ON endOfMonth()

and run it at the end of each month? You could set up a subscription and have it run daily. TBH, I have not used this function so unsure if it is what you are looking for.

All comments

Christos Moysiadis

Hi @Donna Hulme,

Try this maybe : created > endOfMonth(-1) and created <= endOfMonth(-1)

Best regards

------------ EDIT -------------

Or only : created = endOfMonth(-1)

Jack Brickey

I don't know about "previous" month but wondering if you can use something like this...

status was not done ON endOfMonth()

and run it at the end of each month? You could set up a subscription and have it run daily. TBH, I have not used this function so unsure if it is what you are looking for.

Donna Hulme

Thank you! That did it:

issuetype = Bug AND status was in ("In Progress", Information, "Needs Review", "Ready For Dev") on endOfMonth(-1) AND "Dev Team" in ("245", "249")

I appreciate the help.

Donna Hulme

Thanks! I was able to figure it out based on both replies. I appreciate it.

Christos Moysiadis

Hello @Donna Hulme,

i appreciate that my answer helped you! Plz accept my reply so it can help other atlassian users later

best regards and good morning

Welcome!

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

Quick Links

Find more posts tagged with

jira-software