News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum Calculated field to ta...

Dynamics 365 general forum

Suggested answer

Calculated field to take into consideration leap years

(0) Share

Report

Report

Posted on by T.I.A

1,760

Has anybody done this before?

I'm not sure where to start formula wise in the calculated field.

Categories:

Dynamics 365 Administration

Customization / Solutions / SDK and API

All responses Img

All responses (5)

Answers Img

Answers (0)

Suggested answer

Nya 29,054 on at

Like (0)

Report

RE: Calculated field to take into consideration leap years

Hi,

Now I know your proposal.

You can refer to the answer to the following issue.

(+) How to get Accurate Age including leap year calculations? - Microsoft Dynamics CRM Forum Community Forum
T.I.A 1,760 on at

Like (0)

Report

RE: Calculated field to take into consideration leap years

Hi, NVA.

If the birthday is the 29/02/2000 and the next birthday is in 2024 it will be calculated as

28/02/2024 which is slightly off. A leap year has 366 days not 365 so adding 1 year will fail.
Suggested answer

Nya 29,054 on at

Like (0)

Report

RE: Calculated field to take into consideration leap years

Hi,

I have tested the following three date with the similar expression. There is no need to consider the leap years.
T.I.A 1,760 on at

Like (0)

Report

RE: Calculated field to take into consideration leap years

Lets say a contact was born on 29/02/1992, this year there was no 29/02/2021, so what should i be setting the date to?

my formula is AddYears(1, new_nextbirthday)
Nya 29,054 on at

Like (0)

Report

RE: Calculated field to take into consideration leap years

Hi,

Would you please specify in what scenarios do you need to perform calculations for leap years?

Based on my test, if you simply add up the years to the calculation fields, there will be no calculation errors due to leap years.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2

Martin Dráb 228,645 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans