Microsoft Dynamics CRM (Archived)

Calculating Age based on DOB

(0) Share

Report

Posted on by Shane Brown

190

I created a Calculated field using Diffindays to calculate Age based on Today and dob field.

'DiffInDays(cat_dateofbirth, Now()) / 365'

The issue I have it does not take into consideration leap years. Is there anything I could add to the formula to make this work?

Or any code that does the job?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Dynamics365starsolu... 10 on at

Like (0)

Report

RE: Calculating Age based on DOB

Hi Family ,

Please Do Refer Blog of Mine

I hope Your Question will be Answered

dynamics365starsolutions.blogspot.com/.../age-using-javascript-in-d365-to-get-age.html

Was this reply helpful? Yes No
Kishore P 45 on at

Like (0)

Report

RE: Calculating Age based on DOB

Hi ,

Try these:

var DOB =Xrm.Page.getAttribute("DOB").getValue();

var today = new Date();

var birthDate = new Date(DOB);

var age = today.getFullYear() - birthDate.getFullYear();

var m = today.getMonth() - birthDate.getMonth();

if (m < 0 || (m === 0 && today.getDate() < birthDate.getDate())) {

age = age - 1;

}

Xrm.Page.getAttribute("new_Age").setValue(age);

Was this reply helpful? Yes No
Suggested answer

Namrata11 77 on at

Like (0)

Report

RE: Calculating Age based on DOB

You can use Date only field

It is about Date of birth, we can consider as date only field

Was this reply helpful? Yes No
TomSmelser 1,570 on at

Like (0)

Report

RE: Calculating Age based on DOB

This worked for me. Thank you.

Was this reply helpful? Yes No
Bruna Teixeira 5 on at

Like (0)

Report

RE: Calculating Age based on DOB

Hi Namrata,

I've taken a look at your suggestion and I think the problem is to create a new DOB field using User Local behavior. It could be a problem for users in different time zones as the date can change.

I agree with the guys, I think there is no OOB way to solve this.

Was this reply helpful? Yes No
Suggested answer

Namrata11 77 on at

Like (2)

Report

RE: Calculating Age based on DOB

Hi,

I have calculated age using OOB Calculated field.

https://namratapani.wordpress.com/2019/03/20/oob-age-calculation-in-crm/

Please check this once. Worked for me :)

Was this reply helpful? Yes No
Suggested answer

Vipin J 1,603 on at

Like (0)

Report

RE: Calculating Age based on DOB

The business rule where seems to be not working ang giving an error - You can't use Now(), which is of type dateTime, with the current function.

So i wrote a JavaScript to support my calculation of Age. Click Here

vjcity.blogspot.com/.../how-to-calculate-age-in-dynamic-365-crm.html

Was this reply helpful? Yes No
Shane Brown 190 on at

Like (0)

Report

RE: Calculating Age based on DOB

Agreed doesn’t look like it is possible with OOB functionality.

Was this reply helpful? Yes No
Verified answer

CSF90 on at

Like (0)

Report

RE: Calculating Age based on DOB

This is the classic example of a solution that sounds like it should be simple but is actually really complex. You'll need a JavaScript function for it to be accurate - there is no way calculated fields or business rules will be able to work it out for you.

Was this reply helpful? Yes No
Suggested answer

ashlega 34,477 on at

Like (0)

Report

RE: Calculating Age based on DOB

Hi Shane,

why don't you use DiffinYears instead of DiffinDays?

Or are you trying to get a decimal number for the age (as in 10.5, 40.73)?

If that's the case, you might probably try:

DiffinYears(cat_dateofbirth, NOW()) +DiffinDays(ADDYEARS(cat_dateofbirth, DiffinYears(cat_dateofbirth, NOW())), NOW()) / 365

In other words, first get diff in years.. then add the portion of the year which is left after that

There could still be a bit of difference, but it'would only be there if the last year was a leap year

Was this reply helpful? Yes No