filterString with Date Logic

[edmarks]

Looking at the documentation for filterString (IdentityNow Account Filtering during Account Aggregation - Compass) it appears to have “greater than”, “less than” and some basic functions like .isNull, startsWith, etc.

I’m wondering if there’s a way to use a date offset calculation to exclude records with a future hire date (>30 days) or past termination date (<90 days)…

The use case is an web service based authoritative source with start/end dates but not a “Status” to filter these out easily.

[Yathish (yathish Ponnana)]

Hi @edmarks , Date calculations cannot be done using Aggregation filters. Since that is a Web Service based authoritative source you can use before operation rule for aggregation operation and perform required actions