2.25 DateDiff - Calculating Age in Access using Date of Birth

[Legionari3]

Thank you worked fine for me =)

[twelvedangs]

Thanks for the DateDiff tip. Do you know how to calculate age using DOB and specific date instead of now? thanks.

[zopydude]

Fair play. I love you. Your accent reminds me of my home town Swansea

[MyFriendsCallMeGreg]

Beautiful! Just Beautiful!!!! Thank you for posting.

[kaneforrester]

Appreciate this mate, I prefer to watch a YT vid of how to do something as opposed to reading a written tutorial :)

[abadi1010]

nice

thank you

[peterATIAMDlife]

Thank you ^^

[annymfilliu]

okay this may sound like an odd question but is there a way to do this for days instead of years?

[Targus19]

how do i do this in Access 2010????????????

[Firchild]

@Targus19 Exactly as it is here.

[fotobalk]

@Targus19 I dind't worked out for me in Access 2010, so i used semicolons(;) instead of commas(,). No idea why, but it worked for me!

[SGTZlakin]

@Targus19 2010 does the same things a the prior Office programs but has more abilities. So if it can be done here it can be done there the same way.

[CareyBeaufordPortnoy]

OMG YOU JUST SAVED MY LIFE!!! lol

[tmkm130]

Also, I was wondering if there is a way to calculate the difference between two fields that have dates? What is the formula for that? Thank you!!!

[SGTZlakin]

@tmkm130 replace now() with [the field name] and it should work

[tmkm130]

Hi, I wanted to say that I love this function. It's great. However, I have done this and for some reason, it's calculating incorrectly??? It is behind by two months. I checked my time/date setting on the lower left hand side of the computer and it is correct. Is there another area that I need to adjust this so it is correct?

[Firchild]

@tmkm130 Hmmm. that's a funny one. Normally that would be a system clock issue. So I'm a bit at a loss there, sorry!

[Mettagon]

@Firchild i figured out why...its simply because the function finds the difference in years and disregards the months. one month ago, so im prob a bit late.

[SGTZlakin]

@tmkm130 I had a similar issue with the year being off by one. I found this DateDiff("yyyy",[DOB],Now())+I­nt(Format(Now(),"mmdd")<Format­([DOB],"mmdd")) and it works for me. Firchild is still the pro though I just got lucky.

[kartovo]

However, doesn't work in czech short date format: dd.mm.yyyy

Still returns error like Invalid syntax.

[Firchild]

@kartovo Dunno, I'm not Czech

[mitchrc3]

Thanks, this was most helpful.

[xOneShotOneKillx]

Thanks for that =)

[jodesaunois]

great, thx for the help!!!!

[sonmezb]

Thank you so much!!!

[RiKKuXd28]

apart from calculating age what can date diff be used for ?

[abhvor87700]

You just saved my life...THANKS A TONNNNNNN

[dannyweeks12345]

thankyou your a life saver!

[andyv123]

do you not have a problem with the datediff function in that it is slightly incorrect. for example the number of years difference between 30-dec-2009 and 1-jan-2010 is 1??? i normally have to write a vba code to fix this.

[prakus74]

You could try DateDiff("yyyy", [Birthdate], Now())+ Int( Format(now(), "mmdd") < Format( [Birthdate], "mmdd") ) AS Age to work around that issue

[Metaljoxxx123456]

WOW!!!!!! ^__^

[Metaljoxxx123456]

you are GOD!!!!!

[crazeeguyJc]

Thanks a lot, very helpful.

[milloy5]

you are a legend mate this helped with an assignment

[davidjones1965]

Thank you.

[Kingmistry300]

great help. Cheers