Skip to main content
Solved

Birthday next year

  • August 22, 2020
  • 4 replies
  • 57 views
Brite_Admin
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

    4 replies

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • 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
    Brite_Admin
    Forum|alt.badge.img+11
    • Brite_Admin
    • Author
    • Inspiring
    • August 22, 2020

    Thanks Scott, that worked perfectly.

    ScottWorld
    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • 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:

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

    Done! Thanks again.Scott.

    ScottWorld
    Terms & ConditionsAccessibility statement