Age Validation Rule

[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?

 

[Duane Hookom]

Set the date field's validation rule to
<=DateAdd("yyyy",-16,Date())

 

[John Vinson]

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?

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())

will do the trick.

 

[John Vinson]

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.

OOPS!

Less, not greater.