PC Review


Reply
 
 
Hannah
Guest
Posts: n/a
 
      21st Sep 2003
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
 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      21st Sep 2003
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()))

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele


"Hannah" <(E-Mail Removed)> wrote in message
news:039301c38040$3c3b08f0$(E-Mail Removed)...
> 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



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Age from birthdate =?Utf-8?B?TmV2?= Microsoft Excel Worksheet Functions 9 19th Nov 2006 05:51 PM
Please Help Me Get The Age From The Birthdate =?Utf-8?B?ZWFtb24=?= Microsoft ADO .NET 2 8th Aug 2005 06:49 PM
Age/birthdate Joe Holzhauer Microsoft Access Form Coding 3 20th Feb 2005 02:46 PM
how to get age using birthdate =?Utf-8?B?dHluaXl2b25uZQ==?= Microsoft Excel Misc 3 6th Dec 2004 06:09 PM
Birthdate vs age val Microsoft Excel Worksheet Functions 2 3rd Oct 2003 09:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:06 AM.