Calculating age from a birth date in Access using ddmmyyyy format.

[Guest]

Is it possible to calculate age from a birth date in Access (or Excel) 2002
using ddmmyyyy format or do we all have to conform to US standards to use
this function?

 

[Wayne Morgan]

I don't know which function you are speaking of, Access doesn't have a
built-in Age function. However, depending on what you're doing, the
calculation may need to be done in US format, but once you've finished the
calculation you can format it as desired.

 

[Allen Browne]

For a discussion of what works and what doesn't see:
Calculate a person's age, from date-of-birth data
at:
http://allenbrowne.com/func-08.html

For info on how to work with dates in a dd/mm/yy country, see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

 

[Guest]

Use the following expression to return the age:

DateDiff("yyyy", [DOBField], Date()) + (Date() < DateSerial(Year(Date()),
Month([DOBField]), Day([DOBField])))

R. Hicks