+ Start a Discussion
farukh shaikhfarukh shaikh 

I have a requirement to check if Lead is more than 18 years of age before inserting lead. I need to achieve this using validation rule. Can some help me out here.

I have a requirement to check if Lead is more than 18 years of age before inserting lead. I need to achieve this using validation rule. Can some  help me out here.

The validation needs to be done on Date of birth field
Best Answer chosen by farukh shaikh
Khan AnasKhan Anas (Salesforce Developers) 
Hi Farukh,

Greetings to you!

Do you already have an Age field created, assuming it is, the validation rule will be as below:
YEAR(TODAY()) - YEAR(Date_of_birth__c) < 18

Or try this:
(( TODAY() - Date_of_birth__c ) / 365.2425) > 18

Please refer to below link which might help you further:
https://success.salesforce.com/answers?id=90630000000CjloAAC

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.

Thanks and Regards,
Khan Anas