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

IQL Date function to search for objects with a past date returns date in future with year range 2042 to 9999

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 4.15.0, Mindville - Pre Bundled, 4.17.0, 4.16.0
    • None

      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

      1. Create an object with a Date attribute.
      2. 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.
      3. Create another object with the date value in the past e.g. 12/12/2020
      4. 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

              Unassigned Unassigned
              michin Michelle Chin
              Votes:
              8 Vote for this issue
              Watchers:
              11 Start watching this issue

                Created:
                Updated: