AQL Date Attribute Query

[Dustin Alcock]

In Assets I've built out a Software Catalog. One of the attributes is "Last Access Audit" as a Date type value. I'm attempting to setup a global automation that runs daily and will look for any software objects with a Last Access Audit value greater than 180 days.

"Last Access Audit" is EMPTY
Works on all objects where the field is empty. No issues with this.

"Last Access Audit" >= -3d
No results found after putting in a date several months old. Simplifying by looking for older than 3 days instead of 180 to start out. I've also tried just =

[Mikael Sandberg]

AQL does not have the same functions for dates as JQL, but if you use this it should work:

"Last Access Audit" < now(-180d)