How to simply get age with calculated field

(0) Share

Report

Posted on by Community Member

Hello,

I'm very disappointing by Dynamics, some simple thing is not possible without complicated workaround for example I just want get contact Age from calculated field on this entity.

Unfortunately I'm unable use Diffyear with Now() and birdthdate :

DIFFINYEARS(birthdate,NOW()) -> not compatible fields

But

DIFFINYEARS(birthdate,birthdate) -> compatible

DIFFINYEARS(NOW(),NOW()) -> compatible

That very strange isn't it ?

Is there a simple way to do that ?

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

gdas 50,091 Moderator on at

Like (1)

Report

Hi,

This is because NOW() is a date time so you have to make your DOB field format as Datetime in that case instead if date only format. I understand its look odd DOB with time , you can set time with 00 using JS . Here I did have a look below screenshot -

Here is the result -

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank for your reply,

But realy I must create a custom field to calculate that ? That's ridiculous.....

Even is easier in excel to calcultate it

Is there not a possibility to caste birthdate field ?

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Birthdate being the system field, it is not available to change the behaviour/format so you have to create new field with the datetime behaviour in order to use the calculated field functionality. If you still want to use out of box birthday field then you can create a business rule (entity level) to copy the birthday value to your custom dDOB field and then hide that field.

This way, user will set the birthdate on birthday field, which will be copied to custom DOB field and the then the age is calculated from your custom DOB field.

Hope this helps.

Was this reply helpful? Yes No
RugerSR762 375 on at

Like (0)

Report

Any ideas as to why the DIFFINYEARS function only looks at the year but not the actual date? For instance we enter DOB 7/1/2000 and it should return 19 as that is the current age. However, it is returning 20. The same holds true for any date entered (also ran it all they way up through 12/31/2000 and getting 20 as the calculated result). Is there a different, non code solution or would JS be a better approach?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

If you choose the DIFFINYEARS approach you need in total four custom fields:

custom field birthday_custom (Date and Time) with business rule to write the value of oob field birthday into the custom field --> is needed because you cannot use date functions on the oob field

calculated field today with formula Now() --> is needed because you cannot use functions in conditions if using calculated values

calculated field next_birthday with formula AddMonths(DiffInYears(birthday_custom, Now()) * 12, birthday_custom)

calculated field field age with formulas:

if next_birthday greater than today

DiffInYears(new_geburtstagcustom, new_nextbirthday) - 1

else

DiffInYears(new_geburtstagcustom, new_nextbirthday)

Was this reply helpful? Yes No