0

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

1 Answer 1

0

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.

5
  • NOW()-BLANKVALUE(Contact.Last_Survey_Date__c, DATETIMEVALUE(1950,1,1)) > 7. I am trying this but gives error.
    – teeshu
    Commented Jul 12, 2019 at 16:52
  • That should do it Commented Jul 12, 2019 at 16:52
  • Incorrect number of parameters for function 'DATETIMEVALUE()'. Expected 1, received 3
    – teeshu
    Commented Jul 12, 2019 at 17:14
  • use DATEVALUE("2000-01-01") instead Commented Jul 12, 2019 at 17:16
  • Or DATETIMEVALUE( "2000-01-01 12:00:00" ) Commented Jul 12, 2019 at 17:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .