Filter for "Last 3 months" by all resolved statuses

[David Whitley]

I've been trying to create a filter that filters all completed tickets of a component by the last 3 months, for reporting purposes.   I've looked at numerous Altassian posts and this is the best that I've come up with.  It still doesn't work because it doesn't like the >= operator:

status = (Resolved, Published, Completed, Declined, Closed, Accepted, Done) >= startOfMonth() AND component = "End Of Life (EOL)" ORDER BY Rank ASC

[Carlos Garcia Navarro · Accepted solution]

Hi @David Whitley ,

Can you please try this?

status in (Resolved, Published, Completed, Declined, Closed, Accepted, Done) and resolutiondate >= startOfMonth(-3) AND component = "End Of Life (EOL)" ORDER BY Rank ASC

[David Whitley]

That's perfect!  Thank you very much.  Now that I know about resolutiondate, I'll be able to apply this to many of my current reporting filters.  That's exactly what I am after.

[Carlos Garcia Navarro]

You're welcome! I'm glad to hear :-)