We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Advanced Query for create date in Technical rule

Bwagne
New Contributor III
New Contributor III

I have a technical rule that I believe may be running but shows invalid condition when trying to preview.
I'm trying to switch to Advanced query to make sure it is working.

I've tested in data analyzer and it works fine there but this particular command doesn't want to work:
a.createdate >date_sub(curdate(),interval 96 HOUR)

I've looked at the documentation and tried several things, but none seem to work.  I was given this nomenclature from a previous support ticket when running 5.5 now we are on 23.x

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

 

rushikeshvartak_0-1707276119423.png

datediff(a.createdate,now()) <= 96


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

This doesn't give me an error, but it returns all users and not those created within the last 96 hours.

Bwagne
New Contributor III
New Contributor III

This seems to work: a.createdate > subdate(curdate(), 4)

Thanks.

If I switch to >= then I get no users