validate date

J

Jbcrtilla

Within tables I wish to set up a validation rule that only allows date of
birth to be entered if age is greater than 18 from todays date. Can anyone
help me please?
 
O

Ofer

Open the table in design view, in the validation rule of the field
properties, enter

<DateAdd("yyyy",-18,Date())

In the Validation text enter the message that you want to be displayed.
 
Top