Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-11990

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 4.20.1
    • None

      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

              Unassigned Unassigned
              1463fcb5e3fd Sireesha
              Votes:
              5 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated: