You need to sign in to do that
Don't have an account?
CRMandresG
Difference between date fields rule
I have two date fields on my Event.
'Start' (which is standard) and Lead_Date_Assigned__c
I need a rule saying the difference between the 'Start" date and the Lead_Date_Assigned__c cannot be greater then 90 days.
Can someone point in the right direction?
You can subtract dates in validation rules.
So (StartDate - Lead_Date_Assigned__c) < 90 would be your validation rule.
Check out this page for some examples:
http://na6.salesforce.com/help/doc/en/fields_useful_field_validation_formulas.htm#DateValidation
The Date Must Be Within One Year of Today is close to what you are looking for.
Actually, since the formula should return true when an error message is to be displayed, it should check if the difference is greater than 90 days, so it would read as follows:
(StartDate - Lead_Date_Assigned__c) > 90
"Start" is a standard filed,
When I insert that statement into my formula, I get the following Error: Field StartDate does not exist. Check spelling.
I have tried inputting "Start"/ "StartDate"/ "StartDateTime with same message. Does it have to be custom?
Any suggestions?
The standard Event.Start field can't be accessed by Formulas, VR's or WFR, it's a Dead End (sorry)