Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-60877

System Date Fields Are Not Working Properly in JQL

XMLWordPrintable

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      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.

      Workaround

      • Use a day after the desired date to show the issues.
      • Use explicit time eg created <= '2016-05-0418:00'

            Unassigned Unassigned
            cteh Ting (Chiou Ting Teh)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: