Calculate age from Date of Birth

[Alan F]

What calculation would I use in a form to display a persons age if I already
have their Date of Birth.

Many thanks in advance

 

[Stephanie Neveu]

DateDiff

 

[Art]

Hello

DateDiff("yyyy",[DateOfBirth],[Date])

 

[Douglas J. Steele]

Except that that's going to be wrong if the person hasn't had his/her
birthday yet.

DateDiff("yyyy", #12/31/2003#, #1/1/2004#) returns 1 year, despite the fact
it's only 1 day.

To take this into account, use:

DateDiff("yyyy",[DateOfBirth],[Date]) - IIf(Format(Date, "mmdd") <
Format([DateOfBirth], "mmdd"), 1, 0)



--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hello

DateDiff("yyyy",[DateOfBirth],[Date])

-----Original Message-----
What calculation would I use in a form to display a persons age if I already
have their Date of Birth.

Many thanks in advance


.

 

[Alan F]

Hi,

Have tried pasting the code behind a unbound text box called Age and I keep
getting an error, as I missing something. I put it on the on enter event on
the text box. When I paste in the paste is displayed in RED can you help.

Thanks, Alan

Except that that's going to be wrong if the person hasn't had his/her
birthday yet.

DateDiff("yyyy", #12/31/2003#, #1/1/2004#) returns 1 year, despite the fact
it's only 1 day.

To take this into account, use:

DateDiff("yyyy",[DateOfBirth],[Date]) - IIf(Format(Date, "mmdd") <
Format([DateOfBirth], "mmdd"), 1, 0)



--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hello

DateDiff("yyyy",[DateOfBirth],[Date])

-----Original Message-----
What calculation would I use in a form to display a persons age if I already
have their Date of Birth.

Many thanks in advance


.

 

[Guest]

where do you put that code to calculate age from dob

 

[Steve Schapel]

Alan,

Try putting it, preceded with a = sign, in the Control Source property
of the textbox.

 

[Arvin Meyer]

What calculation would I use in a form to display a persons age if I already
have their Date of Birth.

Many thanks in advance

Try this function at the Access Web:

http://www.mvps.org/access/datetime/date0001.htm

I also have a birthday tickler demo database on my website:

http://www.datastrat.com/Download/Birthday2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access