Forums

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

JQL: >= (date) exclude that date unless you include time?

Stephen Hayden
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.
August 7, 2015

I have a line of JQL that includes this:

createdDate >= "2015/07/27 00:00" AND createdDate <= "2015/08/02 23:59"

This returns 284 issues.

Why does the below only return 260?

createdDate >= "2015/07/27" AND createdDate <= "2015/08/02"

Why does the later JQL exclude issues from 8/2, is this something intended that I'm not understanding? Same issue when using created.

This is w/ JIRA 6.2.

1 answer

1 accepted

2 votes
Answer accepted
Justin Carr
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!
August 7, 2015

When the time of day is left off it's defaulted to "00:00"

Your second search is interpreted as;

createdDate >= "2015/07/27 00:00" AND createdDate <= "2015/08/02 00:00"

Either change the date to 2015/08/03 or include the time as in your first search.

 

Edit:

This is also why searches such as 

createdDate = "2015/07/27"

will typically return 0 (unless you actually had issues created exactly at exactly midnight that day).

Stephen Hayden
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.
August 7, 2015

Thanks Justin. Still seems a little strange - mostly because I never noticed this prior and have surely set up countless filters that this either wasn't an issue or it was overlooked - but will keep that in mind going forward.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events