Advanced Query for create date in Technical rule

[Bwagne]

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

[rushikeshvartak]

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

[Bwagne]

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

[Bwagne · Accepted solution]

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

Thanks.

[Bwagne]

If I switch to >= then I get no users