+ Start a Discussion
LisaClLisaCl 

Validation Rule needed to restrict age range

I need a validation rule that will make sure that the Date of Birth for a person (both primary and joint) for Product "ABC", must be between 45 and 90 years old. 

 

Thanks very much!

 

Lisa

Navatar_DbSupNavatar_DbSup

Hi,
Your validation should be like this:
Year( TODAY() ) - Year( Birthdate) < 45 || Year( TODAY() ) - Year( Birthdate) > 90
You can similarly add other date type field here.

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved. 

 

 

skodisanaskodisana

Hi,

 

Below is the community link fof age calculation.

 

http://boards.developerforce.com/t5/Apex-Code-Development/Age-Calculation/td-p/279993

 

Thanks,

Srikanth. K