validate date

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i validate age 1
Criteria for age calculation 5
Handling of null return in number field on form? 4
URGENT - access date of birth validation 9
Formula in Query 5
how to evaluate approx "birthday" knowing "age" and current date 7
Age 9
Date as a value to a textbox as a result from another textbox 1

Top