Back to Top

Age Validation Rule Formula In Salesforce | Min Age Should Be 18 And Max Age Should Be 100

Validation Rule for minimum age at least 18 and maximum age should not be more than 100 years in Salesforce


 OR(TODAY() < ADDMONTHS( Age__c ,216), TODAY() > ADDMONTHS( Age__c ,1200))


Note: Where Age__c is Date type field. 

Why we use 216 & 1200 : 216/12 = 18  And 1200/12 = 100


0comments

Post a Comment