calculate age in query

[Grams]

In that order - years, months, day
=DateDiff("mmddyyyy",[BirthDate],Now())+(Format([BirthDate],"mmddyyyy")>Format(Now(),"mmddyyyy"))
I got the above from a post but when I try it I get #Error

Help
Janet

 

[Douglas J. Steele]

DateDiff will not accept mmddyyyy as a parameter. As well, you don't want to
include yyyy in the Format statements: all you're trying to do is determine
whether or not the birthday has occurred yet this year:

=DateDiff("yyyy",[BirthDate],Now())+(Format([BirthDate],"mmdd")>Format(Now(),"mmdd"))

 

[Douglas J. Steele]

Sorry, just noticed that in another newsgroup you'd posted using a different
subject (that you wanted the age in years, months and days). See
http://www.accessmvp.com/DJSteele/Diff2Dates.html

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

DateDiff will not accept mmddyyyy as a parameter. As well, you don't want
to include yyyy in the Format statements: all you're trying to do is
determine whether or not the birthday has occurred yet this year:

=DateDiff("yyyy",[BirthDate],Now())+(Format([BirthDate],"mmdd")>Format(Now(),"mmdd"))


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

In that order - years, months, days
=DateDiff("mmddyyyy",[BirthDate],Now())+(Format([BirthDate],"mmddyyyy")>Format(Now(),"mmddyyyy"))
I got the above from a post but when I try it I get #Error

Help
Janet