-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
4.20.1
-
None
-
5
-
Severity 3 - Minor
-
1
-
Issue Summary
IQL function that are used for date comparisons like now() , endOfYear() returns incorrect results for dates over 2044.
Steps to Reproduce
- Create a new objectType (License) and include an attribute with the type 'Default' and Type value 'Date'.
- Create a new object and enter the date value as '10/Oct/2044'
- Save it.
- Open the IQL view, and run the query to get all objects with dates less than now()Â
objectType = License and "End Date" < now()
Expected Results
IQL should not return the objects with "End Date" greater than the current date.
Actual Results
IQL returns the objects with "End Date" from the year 2044 too. But if you change the date to 2041. Then it is working as expected and not returning the objects.
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