Birthday next year

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’
)

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')

Thanks Scott, that worked perfectly.

1 Like

Glad I could help! :slight_smile: 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. :slight_smile:

Done! Thanks again.Scott.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.