Search between two dates doesn't seem to be inclusive and is missing some issues

Hello, I have a search string that contains:

created >= 2012-01-01 AND created <= 2012-01-31

I.e.: looking for everything that was created in January 2012. For some reason this is missing an issue that was created on the 31st of January and the string has to be modified to be:

created >= 2012-01-01 AND created <= 2012-02-01

in order to successfully include that particular issue in the results.

Note 1: There is another issue that has a created date of 5th Jan 2012 and if I change the search string to be:

created >= 2012-01-05 AND created <= 2012-01-31

then is it returned successfully.

Note 2: If I switch to simple searching then two fields are labelled:

  • Created after
  • Creader before

which doesn't sound very inclusive.

Trés confused. Anyone have an idea if I am doing something terribly stupid here???

2 answers

1 accepted

This widget could not be displayed.

Simply put, a date in JIRA's world is the date with time as 12:00AM. So "created >= 2012-01-01 AND created <= 2012-01-31" mean everything from 01/01 12:00AM to 01/31 12:00AM. That will miss all issues created on 01/31 after 12:00AM which is mostly everything created on 01/31.

Hope that explains.

Btw, you can use time as well in the query if using the next date confusing. Something like:

created >= "2012-01-01" AND created <= "2012-01-31 11:00"

This widget could not be displayed.

I have the same problem, it is not possible to change the default setting in the date filter for the "TODATE" to 12:00 PM.

Thank you very much


Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

181 views 2 0
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you