Exclude Done Issues Older than 5 months from JQL statement

[Karin Biedermann]

Dear all, 

I am currently filtering for all Issues that are related to my team. I want to exclude all issues that have been set to done in the last 5 months (automatically updating with each day - thus bound to current login).

Could you help me out here?

KR Karin

[John Funk]

Hi Karin,

Add this to your filter: AND status changed to Done > startOfDay(-5m)

[Bill Sheboy]

Hi @Karin Biedermann and @John Funk 

John, did you mean to use AFTER startOfDay(-5M) rather than > startOfDay(-5m) in that query to use months?

Karin, here is some free training and documentation from Atlassian to learn how to make such queries in the future:

• https://university.atlassian.com/student/activity/1225443-intro-to-jql-in-jira-software-course-description
• https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql
• https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-operators-reference-939938745.html

Kind regards,
Bill

[John Funk]

Sorry - yes, thank you for the correction @Bill Sheboy !!