2.25 DateDiff - Calculating Age in Access using Date of Birth
Loading...
Uploader Comments (Firchild)
All Comments (44)
-
Thank you worked fine for me =)
-
Thanks for the DateDiff tip. Do you know how to calculate age using DOB and specific date instead of now? thanks.
-
@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. -
@tmkm130 replace now() with [the field name] and it should work
-
Fair play. I love you. Your accent reminds me of my home town Swansea
-
Beautiful! Just Beautiful!!!! Thank you for posting.
-
Appreciate this mate, I prefer to watch a YT vid of how to do something as opposed to reading a written tutorial :)
-
@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.
-
nice
thank you
-
@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!
5:51
2.26 Password Login Form / screen using VBA in Accessby Firchild102,110 views- 2:46
2.5 Using Logical Operators in Access Queriesby Firchild17,331 views
- 4:27
2.24 Calculated Queries in Access (Calculated Fields)by Firchild20,918 views
- 6:08
2.33 Populating a text box (or control) using a form buttonby Firchild15,254 views
- 9:56
Calculate the difference between datesby dough5171,407 views
- 2:58
Access - Date Type Queryby susanthrall2,379 views
- 2:56
1.5 Adding and Changing Fields in Tables and Forms in Accessby Firchild35,802 views
- 2:34
1.6 Modifying control buttons and adding icons in Accessby Firchild31,454 views
- 1:56
1.8 Creating a Combo Box in Accessby Firchild62,064 views
- 4:16
Access 2007 - creating formulas/calculations in a queryby alanbweaver23,774 views
- 5:10
Microsoft Access Two Dynamic Combo Boxesby 599CD53,170 views
- 1:57
2.4 Using Wildcard * in Access Queriesby Firchild16,114 views
- 1:34
2.11 Creating a Message Box in Access from a Macroby Firchild20,328 views
- 2:19
2.9 Creating a Form from a Query in Accessby Firchild47,888 views
- 2:51
2.22 Adding OLE Objects (Pics) to Tables and Form in Accessby Firchild24,542 views
- 5:11
1.3 (2010) Adding Buttons and Labels to Forms in Access 2010by Firchild8,007 views
- 2:39
Access - Total Query Count Functionby HugoPhongPresents10,847 views
- 2:09
2.2 Using Queries to Sort Data in Accessby Firchild23,795 views
- 5:52
2.18 Using Relationships and Queries to Pull Data from Tableby Firchild28,402 views
- 0:59
MS Excel - Age Calculationby leeginchoi19803,384 views
how do i do this in Access 2010????????????
Targus19 1 year ago
@Targus19 Exactly as it is here.
Firchild 1 year ago
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?
tmkm130 1 year ago
@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!
Firchild 1 year ago
However, doesn't work in czech short date format: dd.mm.yyyy
Still returns error like Invalid syntax.
kartovo 1 year ago
@kartovo Dunno, I'm not Czech
Firchild 1 year ago