[AccessD] Date Diff Help

Almost.

DOB = 5/11/1940

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

=DateDiff("yyyy", [DOB], Now

Returns 172

Help Please
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 9:41 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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