You need to sign in to do that
Don't have an account?
Michelle Arndt
Syntax Error
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.
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.
All Answers
You can find the answer in this link
https://help.salesforce.com/HTViewHelpDoc?id=formula_examples_dates.htm
Please mark it as a best answer if it helps.
Thanks,
IF(DATEVALUE(LastActivityDate) <= 90, checked = true, checked = false)
and I am getting this error
Error: Incorrect argument type for function 'DATEVALUE()'.
I also changed it to
DATEVALUE(LastActivityDate) <= 90
and received the same error message
You don't need the checked = true, checked = false,just TRUE and FALSE.
Also make sure that your formula field is of type checkbox.
Error: Incorrect parameter type for operator '<='. Expected Date, received Number
What I'm hoping to acheive is it for it check the box if there has been activity withing the last 90 days.
I feel like we're so close!