Help

Birthday next year

Solved
Jump to Solution
1737 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Brite_Admin
7 - App Architect
7 - App Architect

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

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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

See Solution in Thread

4 Replies 4
ScottWorld
18 - Pluto
18 - Pluto

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

Brite_Admin
7 - App Architect
7 - App Architect

Thanks Scott, that worked perfectly.

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:

Brite_Admin
7 - App Architect
7 - App Architect

Done! Thanks again.Scott.