Outlook - Contact age Calculations - Is it Possible withing Outlook 2003

[Guest]

Hello Everyone,

Please, can anyone advise if and how to calculate a contacts age for a contact. Birthday tracking is great but it would very helpful to see the contacts age. Also, could a report be run of contacts above , below or between certain age criteria?

Thanks,

Chester

 

[Sue Mosher [MVP]]

See http://www.slipstick.com/contacts/calcage.htm for one approach.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Hello Everyone,

Please, can anyone advise if and how to calculate a contacts age for a

contact. Birthday tracking is great but it would very helpful to see the
contacts age. Also, could a report be run of contacts above , below or
between certain age criteria?

 

[Guest]

Hi Chester

Sorry I posted the wrong reply to your question, but here is how I have calculated the age:

define 2 new fields, 1 to enter the date and another for age
and in AGE use Type =Integer, Format = 1,234, Property to use: value
and in initial value use this formula: IIf([DateInstall]<>"None",DateDiff("yyyy",[DateInstall],Date())-IIf(DateDiff("d",CDate(Month([DateInstall]) & "/" & Day([DateInstall]) & "/" & Year(Date())),Date())<0,1,0),"")

I hope this will help