calculate age in query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grams - 31 Jan 2008 22:13 GMT

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

Reply to this Message

Douglas J. Steele - 31 Jan 2008 22:31 GMT

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"))

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(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

Reply to this Message

Douglas J. Steele - 31 Jan 2008 22:39 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(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
[quoted text clipped - 8 lines]
>> Help
>> Janet

Reply to this Message