Details
-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
6.3.6, 7.6.4, 7.13.5, 8.5.19, 8.20.1, 9.4.14
-
6.03
-
21
-
Severity 2 - Major
-
21
-
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
- 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
- is duplicated by
-
JRACLOUD-39509 Create date between should also consider the end date
- Gathering Interest
- relates to
-
JRASERVER-19828 GREATER THAN operator on Created and Updated including GREATER THAN OR EQUALS
- Gathering Impact
-
JRACLOUD-45226 operators <= (Less than or equal to) and > (greater than) are not working properly with dates
- Closed
- mentioned in
-
Page Loading...