How do I use Previous Month?

[Jeff Thomas]

I'm trying to look for Status Changes in the month previous to the month we are in. How do I write this?

So far I've got this but not sure if it's correct? For example today should show me May's data and when I rerun this in July it should show me Junes data.

Project = STCBP AND status changed during (EndOfMonth("-1m"),now())

[Ilya Turov · Accepted solution]

EndOfMonth() is exactly what it is - end of current month, so EndOfMonth("-1M") gonna be one month before it which is actually startOfMonth()

Also be careful with -1m, since its actually one minute, one month gonna be 1M

so for the issues that changed their status during the previous month I'd use this:

status changed during (startOfMonth("-1M"),startOfMonth())

[Jeff Thomas]

Thank you. This one seems to work... good trick about the "m" vs "M"

project=STCBP and status changed during (startOfMonth("-1M"),startOfMonth())

But since I'm loading everything this month, I'm assuming no results is a pass

How do I use the same for created and/or updated ? Both the below fail for me, it says "The Jira server didn't understand your search query."

project=STCBP and created during (startOfMonth("-1M"),startOfMonth())

or

project=STCBP and updated during (startOfMonth("-1M"),startOfMonth())

Jeff

[Ilya Turov]

created > startOfMonth("-1M") and created < startOfMonth()

same with updated

[Jeff Thomas]

Thank you for all your help.

[Shreya Parekh]

Hi Jeff

Not Sure if you are looking for the last month data or past 1 month data, but what i used for the query to retrieve past 1 month data i.e November 12 - December 12  is 
Project = XXX AND Createdate >= Startofday(-1M). 

Hope this helps :)

[PVS]

Hi @Jeff Thomas 

There is one way you can filter as the last month or the last two month etc...

Ex:

 project = "Project" and status changed during (2019-05-01, 2019-05-30) FROM ("Status 1") TO ("Status 2")

OR 

project = "Project Name" AND status changed FROM "Status 1" TO "Status 2" DURING ('2019-05-01', '2019-05-30') BY "username"

Thanks 

[Jeff Thomas]

Thank you, but I don't want to have to hard code dates... I want to use references to "Last Month" or "Previous Month".

[PVS]

Basically With out dates 

This way you can search between certain dates, by user and by field.

I don't think that you can With out Dates 

I hope this helps somewhat