Skip Navigation
:
Home
:
How to...
:
For Beginners
:
Tips Archive
:
Clever Ideas
:
FAQ
:
Products
:
Search
:
About
:
Teach Yourself Outlook 2003 in 24 hours
Samples
Save Attachment Code
View Internet Header
Calculating Contacts Age
Calculating a contact's age on custom forms
The long formula:
IIf([Birthday]<>"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d",CDate(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())),Date())<0,1,0),"")
The short formula:
(Now() - [Birthday] ) /365