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

operators <= (Less than or equal to) and > (greater than) are not working properly with dates

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Medium
    • None
    • 6.3.6, 7.6.4, 7.13.5, 8.5.19, 8.20.1, 9.4.14
    • JQL

    Description

      When I run the query 'created <= '2015-09-04' it does not include any JIRAs created on 2015-09-04. Less than or equal to is acting like less than, when it should be including the specified date.

      When I run the query 'created > '2015-09-03' it is including any JIRAs created on 2015-09-03. Greater than is acting like greater than or equal to, when it should be excluding the specified date.

      This is affecting all of our reporting that we run in Jira

      Re-Opening this Bug

      Summary

      • When we run this JQL project = <project> AND issuetype in (BUG) AND created >= "2019-10-01" AND created <="2019-10-31" it returns 95 issues and,
      • project = TORF AND issuetype in (TR, BUG) AND created >= "2019-10-01" AND created <"2019-11-01" this returns 100 issues.
      • Technically both should return the same results but first JQL Filter ignores the issues reported on 31st Oct.

      Steps to Reproduce

      1. Run the JQL to list the issue between dates using the operators as above.

      Expected Results

      • JQL should list the issues created in between the dates (including those 2 dates) when equal is used with any of those < or > operators.

      Actual Results

      • Operator <= (Less than or equal to) skipping the issues created on that date.

      Workaround

      No

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              459fc34588fd Jensen Mathews
              Votes:
              55 Vote for this issue
              Watchers:
              62 Start watching this issue

              Dates

                Created:
                Updated: