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
)
)
Here! This super short video will show you how to do it
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.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
