Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

How to filter issues by date range?

I am looking to create a filter for a project that will show the issues created in a certain date range but am having issues creating the syntax. I'm lost on how to create the date range. Any help would be appreciated!

3 answers

1 vote
Taranjeet Singh Community Leader Jan 07, 2019

@Jason Bane As an example, if you want to search for issues created between a date range 1 Jan 2018 to 31 Dec 2018, and want to list them in desceding order by creation date, you can use the below JQL query for your filter:


project = "your-project-name" AND created >= "2018-01-01" AND created <= "2018-12-31" order by created DESC


Please let me know if this helps!

With this JQL the issues from 31 DEC 2018 are not in the list. 

I think, this is the right one:

project = "your-project-name" AND created >= "2018-01-01" AND created <= "2019-01-01" order by created DESC

Like # people like this

Technically <= '2018-12-31' should bring defects from 2018/12/31 and prior
I don't know why it is not working that way


the date with or without quotes is working the same way. Meaning '2018-12-31' or 2018-12-31 work the same way.

I'm using reset API to get the issue details using python requests and it seems like date range is not working.

Suppose I wanted to extract the issue details which has been updated/created between 1st Jan 2018 to 31st Dec 2018. I have tried using below format and it returns all the issue's which has been updated greater than 1st Jan 2018 to till date and not limited to Dec 31 2018.>='2018-01-31&updatedDate<='2018-12-31'

Can someone help on this to retrieve issue's updated or created between date range

For '2018-12-31', system internally treats this as '2018-12-31 00:00:00'.
The createddate is internally stored with time.

Hence you didn't get the jiras created on 31 DEC 2018.

Hope it clarifies.

Like Taranjeet Singh likes this
0 votes
Fazila Ashraf Community Leader Jan 04, 2019

Hi @Jason Bane

You could use something like this:

project=xyz and created  > startOfMonth() and created < endOfMonth()

 gets the xyz issues created in the current month. Refer to other functions in


You can also give specific dates instead of date functions.

Hello, I am having a similar issue. I would like to use the time entry date and not "created". When I try it I get a syntax error. 


Instead of this: created  > startOfMonth(-13)


I would like this: Time Entry Date  > startOfMonth(-13)


Is this possible?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

203 views 6 7
Read article

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