how to define a quick filter for all issues created over three months ago?

[Elissa Nurthen]

I'd like to define 3 quick filters: 

open issues created over 8 months ago

open issues created 6-8 months ago

open issues created 3-6 months ago

what is the best JQL syntax for these queries?

[Trudy Claspill]

Your JQL would need to be

created < value and created > value

for the filters to get issues created within a range.

Refer to

https://support.atlassian.com/jira-software-cloud/docs/jql-fields/#Created

While the value could be something like -30d to specify a date 30 days in the past or -4w to specify a date 4 weeks in the past relative to the current date, there is no option for specifying Months.

You could use the startOfMonth(-3) function to get around this and specify a date 3 months in the past, but with that function the date you would be specifying would be relative to the start of the current month rather than the current date.

Refer to https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfMonth--

open issues created over 8 months ago

created <startOfMonth(-8)

open issues created 6-8 months ago

created < startOfMonth(-6) and created > startOfMonth(-8)

open issues created 3-6 months ago

created < startOfMonth(-3) and created > startOfMonth(-6)