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

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: 4.15.0, 4.16.0, 4.17.0, Mindville - Pre Bundled
    • 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

      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

            Assignee:
            Unassigned
            Reporter:
            Michelle Chin (Inactive)
            Votes:
            8 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated: