Microsoft Dynamics AX (Archived)

Age calculation using x++

(0) Share

Report

Posted on by AX 2012 r3

2,426

Good Morning,

I am trying to calculate age.

i am comparing from today date to given birth date
Exampl - year(Today()) - year(mkdate(1,1,1998))
But i am getting 30
it must be 29
How can i achieve this.
I have seen in some sites
But using that intv function i am getting negative values.
Please show some light on this.
Regards.
Have a great day.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Martin Dráb 239,257 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

2018-1998 clearly is 20, therefore your code doesn't match your requirements.

You should think again how you define age. For example, you may want to round age to the closest year, e.g. age 20.4 would be rounded to 20. Start writing code only when you know what calculation you want to implement.

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

Thanks for your reply.

,

How can we achieve this.

Regards.

Have a great day.

Was this reply helpful? Yes No
Suggested answer

dekaasboer 1,530 on at

Like (0)

Report
Copy link

Link copied!

2018 - 1998 = 20

Was this reply helpful? Yes No
Suggested answer

Rudi Hansen 4,079 on at

Like (2)

Report
Copy link

Link copied!
Except for the fact that 2018 - 1998 is not 30 but 20, that's not really your problem.

The problem is that you are rounding your numbers too early.

static void Job9(Args _args) { real ageDiffReal; int ageDiffInt; ; ageDiffReal = year(Today()) - year(mkdate(1,1,1998)); // Since you take the year of the dates and subtract you will get the wrong result (2018-1998 = 20) info(strFmt('%1',ageDiffReal)); ageDiffReal = (Today() - mkDate(30,6,1998)) / 365; // This is the correct way to do it ageDiffInt = Round(ageDiffReal,0); // And when round down the number. info(strFmt('%1,%2',ageDiffReal, ageDiffInt)); }

Was this reply helpful? Yes No