Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2010, 12:26 AM
turns turns is offline Age Calculator in MS Outlook 2002 SP3 Windows XP Age Calculator in MS Outlook 2002 SP3 Office XP
Novice
Age Calculator in MS Outlook 2002 SP3
 
Join Date: Jun 2010
Location: Haverhill, England
Posts: 1
turns is on a distinguished road
Default 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?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Age Calculator in MS Outlook 2002 SP3 Outlook 2002 and Vista ansentry Outlook 3 05-14-2009 09:35 AM
Age Calculator in MS Outlook 2002 SP3 Outlook 2002 SP3 FlyFAmerica Outlook 2 03-28-2009 10:45 AM
Age Calculator in MS Outlook 2002 SP3 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft