Age Limit Validation Rule

[normanlives8]

We are trying to limit the age when imputting the data on forms.
We have the customers DOB in format (dd/mm/yyyy)and are trying to limit the
age to 18.
Are there any validation rules to help us achieve this...?

 

[Ken Snell \(MVP\)]

You can use a table-level validation rule for this.

Open the table in Design view, click on Properties icon on toolbar, and
enter this expression in the Validation Rule box:

DateDiff("yyyy",[mydate],Date())+(Format("Date","mmdd")<Format([mydate],"mmdd"))>=18

Close the Properties window and save the table.

 

[Douglas J. Steele]

Why not just compare the date being input to DateAdd("yyyy", -18, Date())?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

You can use a table-level validation rule for this.

Open the table in Design view, click on Properties icon on toolbar, and
enter this expression in the Validation Rule box:

DateDiff("yyyy",[mydate],Date())+(Format("Date","mmdd")<Format([mydate],"mmdd"))>=18

Close the Properties window and save the table.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

We are trying to limit the age when imputting the data on forms.
We have the customers DOB in format (dd/mm/yyyy)and are trying to limit
the
age to 18.
Are there any validation rules to help us achieve this...?

 

[Ken Snell \(MVP\)]

That would work as well.