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

Stephen Hayden_r7pekc

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.

Justin Carr_qmqwai

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).