Filter query for a range of days

[Natalie Church]

I am trying to do a filter query to show how many issues between 20 and 49 days old, however when I use the 'in range' query on the 'created date' filter, it doesn't seem to work and will bring up something created 3 days ago

project = *** AND created >= -20d AND created <= 49d

I am fairly new to Jira and not really a developer so I might be putting in an incorrect value in there. Can anyone help?

Thanks 

[Tyler Brown · Accepted solution]

Hey Natalie,

Try using this query:

"project = *** and created <= startOfDay(-20d) and created >= startOfDay(-49d) "

Tyler

[Natalie Church]

Thank you this has worked 

[Jack Brickey]

i think you want this

created <= -20d AND created >= -49d