How do I create a Sheet with Todays birthday

Ask for Help
#1

Hi,
I have a sheet with Name Surname and Day of birth.
I would like to create a new view but only on today’s birthday
But the further that I got is this one:
https://docs.getgrist.com/pfGkg43PUKzo/UsersTest/p/1

The filter try to use this current year, so no user get display.

I would like the filter to show any record from 18 February for any year. and not only from 2023.

#2

I suggest making another column This Year's Birthday, which calculates the date this year to celebrate this birthday on. There are several ways to calculate it; one is:

$Day_Of_Birth.replace(year=YEAR(TODAY()))

Set the type of the column to Date, and then you can create (and save) a filter that only shows rows where this column’s value is today’s date.

#3

It works!. Thanks so much Dmitry!!