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

[Stephen Hayden]

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 · Accepted solution]

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]

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.