I need to validate whether the Last_Activity_c occurred within 90 days of the Anticipated_DUE_DATE__c
I came up with the below formula, but it picks up Last activity Dates that are greater than the 60 days. If Anticipated Due Date is 1/1/18, it needs to pick up activities from 10/1/2017 only.
Last_Activity__c - Anticipated_DUE_DATE__c <= 90
Something like this will work
IF(
ISPICKVAL(Status__c, 'Draft'),
NOW() - LastModifiedDate,
CreatedDate - LastModifiedDate
)
For more info on Formulas and Operators check some of these out
https://help.salesforce.com/HTViewHelpDoc?id=customize_functions.htm&language=en_US
https://developer.salesforce.com/page/An_Introduction_to_Formulas
http://www.salesforce.com/us/developer/docs/usefulFormulaFields/
https://help.salesforce.com/HTViewHelpDoc?id=tips_on_building_formulas.htm&language=en_US
Simple arithmetic operators work when comparing a Date/Time to a Date/Time.
You must do conversions or other operations to extract the parts you need if you want to compare Date to Date/Time.
This Validation Rule: CheckOut_Time__c <= CheckIn_Time__c
Resulted in this:
and this:
Best Answer
IF(Last_Activity_c >(Anticipated_DUE_DATE__c.addDays(90)), False, True)
This formula field of return type checkbox will return "True" ,if Last_Activity_c occurred within 90 days of the Anticipated_DUE_DATE__c.