date range search

[mohammed Asif]

ON Atlassian JIRA (v5.2.11): FOR JIRA Query: I’m expecting search query to execute between “start time from 00:00:01hrs 13/june/2013 to 23:59:59hrs 17/june/2013” in JIRA using search params: created >= 2013-06-13 AND created <= 2013-06-17. AND Outcome I’m expecting is all defects created from 00:00:01hrs 13/june/2013 until 23:59:59hrs 17th june 2013.But this is not the case, I'm getting all bugs created until the end of day 2013-06-16. is my logic right .. let me know

[mohammed Asif]

thx and this is very usefull.

[Florin Manaila]

The behavior does make sense, since the date values provided use day-precision. Since the created date uses the time of day as well, following your logic, 2013-06-17 should be translated to different values depending on the comparator (< or >).

So IMHO, the current behavior is better since it provides some degree of consistency. Additionally, you might want to consider using jql functions like startOfDay() and/or endOfDay().