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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chester - 21 Jan 2004 21:26 GMT

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

Reply to this Message

Sue Mosher [MVP] - 21 Jan 2004 22:46 GMT

See http://www.slipstick.com/contacts/calcage.htm for one approach.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> 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

Reply to this Message

Indu Sehgal - 31 Mar 2004 20:46 GMT

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

Reply to this Message