Aug 22, 2020 07:51 AM
I’m looking for a way to have a calendar view of upcoming birthdays. I can use the formula below to show the CURRENT year’s birthdays but I also want the calendar to show NEXT year’s birthdays so that in December 2020, I could look at the Calendar and see the January 2021 birthdays. I know I need a separate field and have the calendar us both fields but I can’t figure out how to add 1 year to the formula below for the second field.,
DATETIME_PARSE(
DATETIME_FORMAT(
BirthDate,
‘MMMM D’
)&
’ '&
YEAR(
TODAY()
),
‘MMMM D YYYY’
)
Solved! Go to Solution.
Aug 22, 2020 08:28 AM
Let’s say that your current formula field is called “Current Birthday”.
Then your new field would be a formula field that looks like this:
DATEADD({Current Birthday}, 1, 'year')
Aug 22, 2020 08:28 AM
Let’s say that your current formula field is called “Current Birthday”.
Then your new field would be a formula field that looks like this:
DATEADD({Current Birthday}, 1, 'year')
Aug 22, 2020 08:44 AM
Thanks Scott, that worked perfectly.
Aug 22, 2020 08:53 AM
Glad I could help! :slightly_smiling_face: If you don’t mind, could you please mark my comment above as the solution to your question? This will help other people who have a similar question in the future. :slightly_smiling_face:
Aug 22, 2020 09:07 AM
Done! Thanks again.Scott.