View Single Post
 
Old 06-15-2010, 12:26 AM
turns turns is offline Windows XP Office XP
Novice
 
Join Date: Jun 2010
Location: Haverhill, England
Posts: 1
turns is on a distinguished road
Default Age Calculator in MS Outlook 2002 SP3

I am trying to calculate age using Outlook 2002 SP3, but it does not appear to work using dd/mm/yyyy. The code that I am using is;

IIf([Birthday]<>"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d",CDate(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())),Date())<0,1,0),"")

Any suggestions?
Reply With Quote