Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculate age 1

Status
Not open for further replies.
Pamy

Pamy

MIS
Oct 15, 2002
29
SG
ANybody has the formula to calculate age based on DOB
 
Sort by date Sort by votes
Code: 
aged = datediff("yyyy", DOB, date()) - iif(dateserial(year(date()), month(DOB), day(DOB))> date(), 1, 0)
 
Upvote 0 Downvote
?Anybody? More like EVERYBODY. Look for "DOB" and / or / "AGE" in search. You will get a lot of opinions, some even have partial explination(s) of their code.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Upvote 0 Downvote
Excellent example! Now how would you do it for years and days to today's date?
 
Upvote 0 Downvote
See earlier post. SEARCH. This topic has been 'beaten' and particularly recently. I BELIEVE that something on this SPECIFIC topic is posted as "basDob2AgeExt".


MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lmcate
  • Locked
  • Question
Limit the PDF Report to each Agency per Page 1
Replies
3
Views
134
Andrzejek
Andrzejek
w0wsmg
  • Locked
  • Question
CALCULATING AGE AT A SPECIFIED DATE 2
Replies
3
Views
57
dhookom
dhookom
sameh2006
  • Locked
  • Helpful tip
I want to get a field calculated in
Replies
1
Views
50
SkipVought
S
spartansFC
  • Locked
  • Question
Calculating Age for future dates
Replies
2
Views
46
spartansFC
spartansFC
monkeysee
  • Locked
  • Question
Create Calculated Field in Query using multiple fields. 1
Replies
3
Views
74
monkeysee
monkeysee

Part and Inventory Search

Sponsor

Back
Top