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

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    15th November 2018 - 08:03 AM