Create date between should also consider the end date

When searching in JQL using the "Create Date Between" filter, JIRA is considering only the Start date, not the End date. It considers one day before the end date.

Steps to replicate:

Example 1:

• Create one issue today (let's say today is Aug 9th);
• Create a JQL (basic or advanced, doesn't matter) to search issues from Aug 7th to Aug 9th (created >= 2014-08-07 AND created <= 2014-08-09);
• The issue will not appear in the results.

Example 2:

• Create one issue today (let's say today is Aug 9th);
• Create a JQL (basic or advanced, doesn't matter) to search issues from Aug 7th to Aug 10th (created >= 2014-08-07 AND created <= 2014-08-10);
• The issue will appear in the results.

Example 3:

• Create one issue today (let's say today is Aug 9th);
• Create a JQL (basic or advanced, doesn't matter) to search issues from Aug 9th to Aug 10th (created >= 2014-08-09 AND created <= 2014-08-10);
• The issue will appear in the results.

Expected behavior:

This should work in any of the scenarios above, including up to 23:59 on the date created. According to bugmaster in JRA-39465:

created <= 2014-08-09 gets translated to 2014-08-09 at 00:00:00 (midnight) so any issues created after midnight will not be included.

Recommended behavior

Include through 23:59:59 that day. This seems more intuitive.

Original text:

I saw this created as a bug on JRA-39645 and as it was confirmed as a "by design" behavior, I think we could improve the code to make this more intuitive for our users.

So the expected new behavior should be like this:

• Create one issue today (12th August)
• Create a JQL (basic or advanced, doesn't matter) to search issues from Aug 7th to Aug 12th (_created >= 2014-08-07 AND created <= 2014-08-12);
• This issue should appear here.

I really think that this is pretty much more intuitive as the customer will use the last day that it needs to see its issues.

Best regards.
Diego Zarpelon
Atlassian JIRA Support Engineer