#1
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2002 and Vista | ansentry | Outlook | 3 | 05-14-2009 09:35 AM |
Outlook 2002 SP3 | FlyFAmerica | Outlook | 2 | 03-28-2009 10:45 AM |
Problem with Outlook 2002 | clemieux | Outlook | 2 | 12-20-2008 11:53 AM |
Outlook 2003 Back To Outlook 2002 (PST File) | caxtin | Outlook | 0 | 06-11-2008 02:02 PM |
SET UP OF OUTLOOK 2002 | bubba622 | Outlook | 0 | 11-06-2006 04:47 PM |