Announcements
Hi All
I have configured a calculated field to calculate the next birthday on a contact. Here is the formula:
AddYears(1, new_dateofbirththisyear)
it works fine for all dates except for those that fall on the 26 or 27th of march (any year) oddly. does anyone have any ideas. If it helps the behavior of the field is user local and the format is date only
Errors:
working fine
Hi,
Yes, it cannot be reverted directly.
But you can create 2 new fields to test if it works.
Only thing is once I do this I won't be able to revert the change.
Hi,
Please try to switch the option into "Date only" and find if the error still exists.
correct. date of birth this year and next year will be calculated fields. the behavior for all fields is user local. Also how do you take into a consideration if a birthday falls on a leap year?
Hi,
I created a calculated field that adds a year directly to the birthday field.
But it can work normally.
I noticed that in your expression there is another custom field "new_dateofbirththisyear".
Is it a calculated field?
If yes, will the value of this field have the same problem?
Also, I'd like to confirm the next properties of the two fields. - "new_dateofbirththisyear" and "Next birthday".
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156