Birthdate

H

Hannah

I am trying to use a validation rule where if they have
to be at least 16 years old. I do not know how to use
the date(). It's for one of my classes, can someone help?

Thanks
Hannah
 
D

Douglas J. Steele

If all you want to do is determine whether or not they're currently 16,
determine what date was exactly 16 years ago, and see whether or not they
were born before that.

To determine the date exactly 16 years previous to today, you can use either
DateAdd("yyyy", -16, Date()) or DateSerial(Year(Date()) - 16, Month(Date()),
Day(Date()))
 

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

Top