Skip to main content
Solved

Birthday next year

B
Forum|alt.badge.img+11

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

Best answer by ScottWorld

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

View original
    Did this topic help you find an answer to your question?

    5 replies

    ScottWorld
    Forum|alt.badge.img+33
    • ScottWorld
    • Brainy
    • 8851 replies
    • Answer
    • August 22, 2020

    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

    RonniEloff_VKDe
    J
    2 people like this
    • RonniEloff_VKDe
      RonniEloff_VKDe
    • J
      jmshade0723
    B
    Forum|alt.badge.img+11
    • Brite_Admin
    • Author
    • Inspiring
    • 35 replies
    • August 22, 2020

    Thanks Scott, that worked perfectly.

    ScottWorld
    1 person likes this
    • ScottWorld
      ScottWorld
    ScottWorld
    Forum|alt.badge.img+33
    • ScottWorld
    • Brainy
    • 8851 replies
    • August 22, 2020

    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:

    B
    Forum|alt.badge.img+11
    • Brite_Admin
    • Author
    • Inspiring
    • 35 replies
    • August 22, 2020

    Done! Thanks again.Scott.

    ScottWorld
    1 person likes this
    • ScottWorld
      ScottWorld
    J
    Forum|alt.badge.img+1
    • jackjeff
    • New Participant
    • 1 reply
    • April 2, 2025

    That sounds like a great way to stay ahead with birthday reminders! If you're also looking for unique and heartfelt birthday messages in Marathi. It has a fantastic collection of wishes to make birthdays extra special!

    Reply


    Most helpful members this week

    Terms & Conditions