You need to sign in to do that
Don't have an account?
Simple validation rule not working
Hi ,
I am using a validation rule which displays an error when billing start date greater than or equal to billling end date .
My validation rule is :AND(Billing_start_date__c >= Billing_end_Date__c)
But this validation rule is displaying error even when the billing start date less than end date.
The validation rule is working fine in the case of edit but when we are insering a new record then it is showing an error.
I am sharing the screenshot can some one help me on this.
Regards,
Kiran
I am using a validation rule which displays an error when billing start date greater than or equal to billling end date .
My validation rule is :AND(Billing_start_date__c >= Billing_end_Date__c)
But this validation rule is displaying error even when the billing start date less than end date.
The validation rule is working fine in the case of edit but when we are insering a new record then it is showing an error.
I am sharing the screenshot can some one help me on this.
Regards,
Kiran
I have removed that AND condition and used billing_start_date__c >= billing_end_date__c still it is not working
Here is link provide by salesfore on Date field validation.
https://developer.salesforce.com/docs/atlas.en-us.usefulValidationRules.meta/usefulValidationRules/fields_useful_validation_formulas_date.htm
"End Date Cannot Be Before Begin Date"
Or you can chang the formula by this
-Thanks
Ashlekh Gera