Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Managing Filters

John Torres
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 28, 2021

Hi All,

I need to create a filter where in; I can catch the data created between 4-6 days and 7-8 days

2 answers

2 accepted

2 votes
Answer accepted
Jack Brickey
Community Champion
October 28, 2021

Hi @John Torres , your question isn’t quite clear. Can you clarify? Are you asking for a JQL that will return issues created earlier than 4d ago but less than 7d ago? If so try the following…

project = xxx and createdDate <= startOfDay(-4d) and createdDate >= startOfDay(-7d)

change to meet your precise needs

1 vote
Answer accepted
Support Team [Clearvision]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 28, 2021

Hi John,

You can try the following:

created > startOfDay(-6) and created < endOfDay(-4)

To return Issues created between 4 and 6 days ago.

created > startOfDay(-8) and created < endOfDay(-7)

For Issues created between 7 and 8 days ago.

Hopefully that is what you were after, please let us know if that works.

Suggest an answer

Log in or Sign up to answer