Age Calculator in MS Outlook 2002 SP3
Asked By
30 points
N/A
Posted on - 02/26/2013
Hello,
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?Â