You need to sign in to do that
Don't have an account?
Michelle Arndt
Formula Help
I have a formula field as a checkbox and this is the formula:
(TODAY() - LastModifiedDate ) <= 30
I get and error stating: "Error: Incorrect parameter type for operator '-'. Expected Number, Date, received DateTime"
I want this box to check if there has been activity within the last 30 days.
(TODAY() - LastModifiedDate ) <= 30
I get and error stating: "Error: Incorrect parameter type for operator '-'. Expected Number, Date, received DateTime"
I want this box to check if there has been activity within the last 30 days.
(TODAY() - DATEVALUE(LastModifiedDate ) ) <= 30
Regards,
Mahesh
All Answers
(TODAY() - DATEVALUE(LastModifiedDate ) ) <= 30
Regards,
Mahesh
IF(((TODAY() - DATEVALUE(LastModifiedDate))<=30), true, false)
Thanks
Sandeep Singhal
http://www.codespokes.com/