Birthday, Age, and Recurring Event in Calendar

  • Thread starter Thread starter Jano
  • Start date Start date
J

Jano

I have added a custom field on contacts which calcs age using this
formula found:


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

Formula was found on:

http://www.outlook-tips.net/howto/age_form.htm

I see a recurring event on the birthday in the Calenday which says:

Contact Name's Birthday

Cool!

Is there any way to do this:

Contact Name's Birthday (Age)

Using the custom field Age in the contact item?

Thanks!!
 
You might want to post this as a question to Diane on Outlook-tips.com to
see if she has an answer.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After searching google.groups.com and finding no answer, Jano asked:

| I have added a custom field on contacts which calcs age using this
| formula found:
|
|
|
IIf([Birthday]<>"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d",CDate(Month([Birthday])
| & "/" & Day([Birthday]) & "/" & Year(Date())),Date())<0,1,0),"")
|
| Formula was found on:
|
| http://www.outlook-tips.net/howto/age_form.htm
|
| I see a recurring event on the birthday in the Calenday which says:
|
| Contact Name's Birthday
|
| Cool!
|
| Is there any way to do this:
|
| Contact Name's Birthday (Age)
|
| Using the custom field Age in the contact item?
|
| Thanks!!
 
Back
Top