validate date

  • Thread starter Thread starter Guest
  • Start date Start 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?
 
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
URGENT - access date of birth validation 9
Handling of null return in number field on form? 4
how to evaluate approx "birthday" knowing "age" and current date 7
Formula in Query 5
Age 9
Date as a value to a textbox as a result from another textbox 1

Back
Top