Can I create a "dynamic" filter that shows all issues more than a year old?

[Justin Corcoran]

I know I can create a filter that is NOT dynamic that will show all issues more than a year old like this:

project = "System Issues" and createdDate < '2011/01/25'

But I'd like the date to be dynamic, so it'd be something like project = "System Issues" and createdDate < 'now() + 365d'

Is this possible? The exact query I have above does not accomplish this goal.

[Nic Brough -Adaptavist- · Accepted solution]

Leave out the "now" function and use a - to say "ago". Createddate >-365d

Actually, try to swap to the simple filter and use the helpful "from / to" help popup to get the clause you need, then swap back to JQL if you need to.

[NielsJ]

Cool, I didn't knew that :-)

[Justin Corcoran]

worked like a charm, thanks!

[Mike Huber]

created < -365d

[NielsJ]

The JQL Enhancement Functions plugin seems to provide what you like:

created <= periodstart(year, -1)

https://plugins.atlassian.com/plugin/details/22514