Valery
Registered User.
- Local time
- Today, 16:43
- Joined
- Jun 22, 2013
- Messages
- 363
Hi everyone!
I am using the expression below, in a form control, to get the age from a date of birth. In this database, it is very important that it be accurate as when the member turns 16, some paperwork has to be issued among other actions.
Expression: =DateDiff("yyyy",[txtDOB],Date())
Noticed yesterday that a member whose DOB is 20-May-2000, returned 16 years old. But in fact, he is still 15 years old with 3 months or so to go!
How difficult or simple is it to adapt this expression to be more accurate? I am a newbie of sorts...
Thank you!
I am using the expression below, in a form control, to get the age from a date of birth. In this database, it is very important that it be accurate as when the member turns 16, some paperwork has to be issued among other actions.
Expression: =DateDiff("yyyy",[txtDOB],Date())
Noticed yesterday that a member whose DOB is 20-May-2000, returned 16 years old. But in fact, he is still 15 years old with 3 months or so to go!
How difficult or simple is it to adapt this expression to be more accurate? I am a newbie of sorts...
Thank you!