UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Calculating Age, Any Version    
 
   
Jerry Dennison
post May 30 2002, 08:28 PM
Post#1


Head Wizard
Posts: 14,857
Joined: 31-January 00
From: South Carolina, USA


The following will calculate an age based on the current date (inclusive). Special thanks to R. Hicks for help with development.

Age: DateDiff("yyyy",[DOB],Date())+(DateSerial(Year(Date()), Month([DOB]), Day([DOB])) >= Date())
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 11:28 PM