IF(LastActivityDate <= 90 Day, checked = true, checked = false)
Can someone please help me with this formula? I am getting a syntax error and I think it might have to do with the Day
, but not 100% sure.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityA Boolean operator is already a Boolean. Therefore, all you need to do is compare to if it's less than 90 days. Subtracting two dates results in a number in terms of number of days. So, your formula should be either:
// Displays checked if it has been more than 90 days
TODAY() - DATEVALUE(LastActivityDate) > 90
--- or ---
// Displays checked if it has not yet been 90 days
TODAY() - DATEVALUE(LastActivityDate) <= 90
Try this:
(Now() - LastActivityDate) <= 90
IF((Now()- CreatedDate) <= 90,true,false)
.
Feb 22, 2016 at 18:39
IF(condition, true, false)
is identical to (and more verbose than) just condition
.
checked = true
mean? Are you trying to set a field? Or do a Validation Rule? Or something else?