Birthdate

  • Thread starter Thread starter Hannah
  • Start date Start date
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
 
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()))
 
Back
Top