Forums

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

How do you create a range for 30-59 days?

Fernandez, Katie
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!
July 14, 2022

Hello,

I am needing to create a filter for any tickets created between 30-59days,  60-89days, 90-119days, etc. 

We have tried to create filters for tickets created 30d+, 60d+ and 90d+ but that results in many duplicates since anything in the 60d+ will also be in the 30d+ and the same thing for the 90d+.

I've been trying to use the following format below but it isn't pulling any results. Please Help!

createdDate >= startOfDay(-30d) AND createdDate <= endOfDay(-59d) AND Resolved is EMPTY

2 answers

2 votes
Fernandez, Katie
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!
July 14, 2022

Nevermind, I figured it out. Leaving this here incase anyone else finds it useful. :) 

 

and created <= startOfDay(-30d) and created >= startOfDay(-59d)

0 votes
Jack Brickey
Community Champion
July 14, 2022

Hi @Fernandez, Katie 

Can you try the following? This should yield last 30d. To prevent overlap you can omit the greater than or less then on one side of your boundaries

createdDate >= startOfDay(-60d) AND createdDate <= startOfDay(-30d)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events