Age in years, months, and days

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

How do I create a query that will tell me how old a person
is in years, months and days. Example: dob: 2/15/94
Retirm value of 10 years, 0 months, 5 days.
 
Tony said:
How do I create a query that will tell me how old a person
is in years, months and days. Example: dob: 2/15/94
Retirm value of 10 years, 0 months, 5 days.
Click to expand...

Use the DateDiff function three times, all three comparing your date to
the Date() function. (See Help on DateDiff)

example years: datediff("yyyy",yourdate,date())
 
Tony said:
I was unable to read your response.
Click to expand...

Huh? Internet trouble.
How do I create a query that will tell me how old a person is in
Click to expand...
years, months and days. Example: dob: 2/15/94 Retirm value of 10 years,
0 months, 5 days.


Use the DateDiff function three times, all three comparing your date to
the Date() function. (See Help on DateDiff)

example years: datediff("yyyy",yourdate,date())
 
Back
Top