calculation

  • Thread starter Thread starter Queent
  • Start date Start date
Q

Queent

Can anyone help me; I need to do a calculation to add a constraint to the D.O.
B field so no one under the age of 14 years will be expected in to the
database field of D.O.B
 
Try this in the Validation rule for DOB in the table:
<Now()-14*365.25
You'll probably want to enter the text you want displayed when a not valid
date is entered.
 

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

Display Calculated Fields and Save Data on Form 2
Datediff & bissextile year 16
Entereing an age and if statement in the same cell 1
calculation 1
Calculating Birthdates 5
Display Age 7
Need help on how to pass calculated field from a form to another form 0
what is the formula for getting current age from Date of Birth 5

Back
Top