Calculate the age (1 Viewer)

gstylianou · Oct 18, 2019

theDBguy said:
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

theDBguy · Oct 18, 2019

gstylianou said:
Hi,

The comma is requirement

Hi. Thanks. Do you have a link? If not, that's okay. Cheers!

Gasman · Oct 18, 2019

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

theDBguy · Oct 18, 2019

gstylianou said:
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.

Pat Hartman · Oct 21, 2019

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?

gstylianou · Oct 21, 2019

Pat Hartman said:
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..

theDBguy · Oct 22, 2019

gstylianou said:
Was just some examples without any meanings..

Hi. Did you try out the demo I posted? Just curious...

gstylianou · Oct 23, 2019

theDBguy said:
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

theDBguy · Oct 23, 2019

gstylianou said:
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!

Calculate the age (1 Viewer)

gstylianou

Registered User.

theDBguy

I’m here to help

Gasman

Enthusiastic Amateur

theDBguy

I’m here to help

Attachments

Pat Hartman

Super Moderator

gstylianou

Registered User.

theDBguy

I’m here to help

gstylianou

Registered User.

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread