Summary

Steps to Reproduce

1. Issue Navigator > Advanced
2. JQL: created <= 2016-05-04
3. Check the result, it does not include the issues created on 2016-05-04
4. Same thing goes for "updated" and "resolved".

Expected Results

Issues created/updated/resolved on the date stated should be shown.

Actual Results

Only issues created/updated/resolved on days before the date stated are shown.

Notes

• Custom date fields are not affected.
• Date 2016-05-04 means 2016-05-04 00:00:01 behind the scene, which explains why search returns now results.
• Using > has the complete opposite behaviour where it includes the date as if you're using >=.

Workaround

• Use a day after the desired date to show the issues.
• Use explicit time eg created <= '2016-05-0418:00'
• When looking for results regarding a specific date (for example, 2020/09/30), it's possible to use the following:

  resolved >= "2020/09/30 00:01" AND resolved <= "2020/09/30 23:59"