Trouble creating birthday calendar

I have a table that has profiles for all of my team members. The team members add their birthdays as one of the columns. I want to create a calendar that shows the birthday for the current year.

For example, Team Member A’s birthday is June 2nd, 1995. So I want that to show up in the calendar view as June 2nd, 2024 so that we know her birthday is coming up.

However, the formula I wrote is changing the current year to 1970 for some reason. What do I have wrong? (See screenshots)



Hi,
juste add (), ex :

today().year()

if you’re looking for the next birthday. For example, on February 2, the next anniversary will be in 2025. Here’s an example:

WithName(
  Date(
    today().Year(),
    thisRow.[date of birth].month(),
    thisRow.[date of birth].day()
  ),
  date_actual_year,
  if(
    date_actual_year < Today(),
    date(
      today().Year() + 1,
      thisRow.[date of birth].month(),
      thisRow.[date of birth].day()
    ),
    date_actual_year
  )
)
1 Like

Hmmm… I tried that but it’s still not working. What am I missing?

Here! This super short video will show you how to do it

1 Like

It seems your formula may be referencing the wrong date format or encountering a calculation error. Check your formula for date parsing or consult with a spreadsheet expert for accurate adjustments.

I was able to fix it. I was already using the formula in your video, @Scott_Collier-Weir (Thank you for sharing that!), but the problem was that I had the column set to a Date column and I was using the Autopopulate Formula feature within the Date column. I fixed the issue by changing the column type to a Formula and then using the Date() formula in the Autopopulate Formula area.