Calculate the age

Hi. Good luck. I'm just curious, could you post a link to the child development standards from the WHO? I'm just curious about the formatting requirements. For example, is the comma a requirement or not? Thanks!

Hi,

The comma is requirement
 
The only comma I see in the output you require is after years ?
Just amend that string in arnelgp's code?
 
Dear all,

First i would like to thanks for your help. But, i need to have the age result as a number like the following example:

Because the age accuracy it's very critical issue for my database because it concerns a pediatrician software which using child development graphs direct from the World Health Organization, the exact results of the child age must be calculated as follows:

Example 1:
[DateAdded]: 10/10/2019
[DOB] = 01/10/2019

RESULTS MUST BE
[FirstAge]: 0,010
* Results: 0, 010 (0 = years , 0 months and 10 days)

[TodayAge]: 0,017
* Results: 0, 017 (0 = years , 0 months and 17 days)

Example 2:
[DateAdded]: 01/06/1999
[DOB] = 22/04/1996

RESULTS MUST BE
[FirstAge]: 3,222
* Results: 3,222 (3 = years , 2 months and 22 days)

[TodayAge]: 23,1017
* Results: 23, 1017 (23 = years , 10 months and 17 days)
Hi. Okay, I gave it a try using the code from the link I posted earlier. I'm not sure how different it is from Arnel's code, but I just noticed I'm getting a different result than your examples, so I was wondering if you require an "accurate" age, what is your formula for calculating them? If it's defined in the WHO standard, I haven't had a chance to look at it yet. But just as an example, in your sample data above, you said a person born on 22/04/1996 would have today's (today = 10/10/2019 or month of October, at least) age as 23 years, 10 months, and 17 days. I want to ask about the "10 months part." If the month of DOB was April and today's month is October, how could that be a 10 months difference? From April to October should be only 6 months max.


Below is a screenshot of my test results, and attached is the test db I used.


attachment.php
 

Attachments

The Age field doesn't make any sense. There are cases where you wouldn't be able to tell if you have a 1 digit month or a 1 digit day. What is 22,123? is it Jan 23 or Dec 3?
 
The Age field doesn't make any sense. There are cases where you wouldn't be able to tell if you have a 1 digit month or a 1 digit day. What is 22,123? is it Jan 23 or Dec 3?

Was just some examples without any meanings..
 
Hi. Did you try out the demo I posted? Just curious...

Morning,

Yes, is working perfect but needs some changes which i must inform you later on...Anyway, is wonderful example

thanks again for your time
 
Morning,

Yes, is working perfect but needs some changes which i must inform you later on...Anyway, is wonderful example

thanks again for your time
Okay, thanks. Let us know what else you need when you get a chance. Cheers!
 

Users who are viewing this thread

Back
Top Bottom