It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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.

3 answers

1 accepted

2 votes
Answer accepted

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.

Cool, I didn't knew that :-)

worked like a charm, thanks!

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

created <= periodstart(year, -1)

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

created < -365d

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you