Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Birthday next year

Solved
Jump to Solution
1998 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')

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

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

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

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.