[AccessD] Date Diff Help

Moral

Never, Ever use a copied text box. To many damn places the
formatting can kill you.

I got it now.

I think.

Joe Hecht
jmhecht at earthlink.net
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Joe Hecht
Sent: Friday, January 06, 2006 8:52 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Date Diff Help

I am trying to do a an age calculation with the following
data source.

 

=DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd"))

 

DOB is the employees date of birth.

 

If Dob is 5/11/1940 I am expecting to get 65 back not 172.

 

TIA

 

Joe Hecht

jmhecht at earthlink.net

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com