Filter for last 3 months

[Roja Gurram]

Hi All,

Is it possible to create a filter that shows issues from the last 3 months?

[Sachin · Accepted solution]

Hello @Roja Gurram , welcome to atlassian community! See created > startOfMonth(-2) ORDER BY created DESC and Search for issues that were created on previous month 

[Roja Gurram]

Hi Sachin,

Is this the article   created > startOfMonth(-2) ORDER BY created DESC or Query ? If article i have read this already JQL is not there for last 3 months.

Can you please provide the exact filter for last 3 months pls ?

[Sachin]

This is the JQL (filter) last three months:
- created > startOfMonth(-2) ORDER BY created DESC

[Roja Gurram]

Thanks four help SACHIN.

[Sachin]

Your welcome!

[Laszlo Mako]

That won't always give you the last 3 months though, will it? If you're at the beginning of a month, say 3rd of Oct, startOfMonth() will get you to 1st of Oct, less two months, 1st of Aug, you'd only get 64 days.

I think what Roja was after is more like created > startOfDay(-90)

[v.petrov]

is it possible to find ALL issues which were in some statuses, not only CREATED that period?

[Jens]

I guess it depends on how you interpret the question.

I would always interpret it as "Issues created within a period of 3 months back" in which case:
 - "created > -90d ORDER BY created DESC"
would be more accurate IMO as i 90 days roughly adds up to 3 months.

However, if your thinking of it as if I am on any day in October, I want the see issues created for the months August, September and October (the past 3 actual months) . then the other Query is correct.