ChrisFaye1
5 years agoQrew Cadet
Anniversary Date Formula
Hi!
Looking for a Formula (or other option) to convert anniversary date to anniversary month/day with current year. I would like to set this up so that it's always assuming the current year and therefore can be used to trigger a reminder.
I know there's a lot of older posts asking a similar question. Hoping there's an up to date solve since some of them seem pretty hairy.
The logic would look something like this - I realize date field's don't work like this, but to help illustrate the question -
Month(A Date) + Day(A Date) + CurrentYear()
Thank You!
------------------------------
Chris
------------------------------
Looking for a Formula (or other option) to convert anniversary date to anniversary month/day with current year. I would like to set this up so that it's always assuming the current year and therefore can be used to trigger a reminder.
I know there's a lot of older posts asking a similar question. Hoping there's an up to date solve since some of them seem pretty hairy.
The logic would look something like this - I realize date field's don't work like this, but to help illustrate the question -
Month(A Date) + Day(A Date) + CurrentYear()
Thank You!
------------------------------
Chris
------------------------------