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!  

[Jack Brickey · Accepted solution]

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]

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

[Christos Moysiadis · Accepted solution]

Hi @Donna Hulme,

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

Best regards

CM

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

Or only : created = endOfMonth(-1) 

[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.

[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

CM