Age Validation Rule

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

I am supposed to create a validation rule to prevent the
input of data for customers less than 16 years of age
from today's date. How do I do this?
 
I am supposed to create a validation rule to prevent the
input of data for customers less than 16 years of age
from today's date. How do I do this?
Click to expand...

You obviously need to know the customer's date of birth to do this;
assuming that it's in the field DOB, a validation rule on DOB of
DateAdd("yyyy", -16, Date())
Click to expand...

will do the trick.
 
You obviously need to know the customer's date of birth to do this;
assuming that it's in the field DOB, a validation rule on DOB of


will do the trick.
Click to expand...

OOPS!

Less, not greater.
 
Back
Top