Has anybody done this before?
I'm not sure where to start formula wise in the calculated field.
Has anybody done this before?
I'm not sure where to start formula wise in the calculated field.
Hi,
Now I know your proposal.
You can refer to the answer to the following issue.
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.
Hi,
I have tested the following three date with the similar expression. There is no need to consider the 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)
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,645 Most Valuable Professional
nmaenpaa 101,148