Insight IQL functions related to date comparison returns incorrect results for dates over 2044.

XMLWordPrintable

    • 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

      1. Create a new objectType (License) and include an attribute with the type 'Default' and  Type value 'Date'.
      2. Create a new object and enter the date value as '10/Oct/2044'
      3. Save it.
      4. Open the IQL view, and run the query to get all objects with dates less than now() 
      5. 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

            Assignee:
            Mingyi Yang
            Reporter:
            Sireesha
            Votes:
            5 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: