Survey should not sent if last survey date is less than 7 days

Question

I am implementing a workflow rule when last survey date is less than 7 days.

I am trying to implement null scenario here when last survey date is null survey should go.

NOW()-BLANKVALUE(Last_Survey_Date__c, Now())) > 7 

But when last survey date is null also survey is going which is not expected. How do i handle null scenario here

Answer 1

Your logic is wrong here

You're assuming that the date is NOW() If a Survey Date is null, but NOW() - NOW() is never going to be > 7

Instead of NOW() for the BLANKVALUE choice, use a date sufficiently in the past, like '2000-1-1' or similar.