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

Question

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 P Claspill · Answer

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 3-6 months ago created < startOfMonth(-3) and created > startOfMonth(-6)