Teach Yourself Outlook 2003 in 24 hours

Samples

 

 

 

Calculating a contact's age on custom forms

The long formula:

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

The short formula:

(Now() - [Birthday] ) /365