-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
4.15.0, Mindville - Pre Bundled, 4.17.0, 4.16.0
-
5
-
Severity 3 - Minor
-
0
-
Issue Summary
IQL Date function to search for objects with a past date returns date in future with year range 2042 to 9999
Steps to Reproduce
- Create an object with a Date attribute.
- Set the value of the Date attribute to some date range 2042 to 9999. To make sure the year is registered as it is, enter the 4-digit year.
- Create another object with the date value in the past e.g. 12/12/2020
- After the creation of the objects, search with IQLs below with the attribute name replaced accordingly.
"Expire Date" < now() "Expire Date" < -1d
Expected Results
The IQL is looking for objects with Expire Date in the past and hence, only the object with the past date (12/12/2020) in the result
Actual Results
Both objects show up in the result
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available
- is caused by
-
JSDSERVER-12123 Assets Objects Date Attributes incorrectly recognize future dates after year 2030 as past century when entered via keyboard
-
- Gathering Impact
-
- relates to
-
JRASERVER-77670 Java Date / Date Time picker setting the wrong year value in a Date / Datetime field
-
- Closed
-
- links to
[JSDSERVER-8492] IQL Date function to search for objects with a past date returns date in future with year range 2042 to 9999
Labels | New: ril |
Remote Link | New: This issue links to "Internal ticket (Web Link)" [ 955292 ] |
UIS | Original: 1 | New: 0 |
UIS | Original: 0 | New: 1 |
Link |
New:
This issue relates to |
UIS | Original: 1 | New: 0 |
UIS | Original: 0 | New: 1 |
UIS | Original: 1 | New: 0 |
UIS | New: 1 |
I have the same issue, that is impacting our organization !