-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
4.15.0, Mindville - Pre Bundled, 4.17.0, 4.16.0
-
None
-
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