Sheet action - select values in a field - not working for year

[user467341]

Hi all,

I created an action in my sheet using "Select values in a field", pointing to my Year column. I confirmed that my Year column is a data type of date. When I input the value, the sheet is not filtering the year for some reasons. I tried a few combination and none works. Here is what I tried:

=2023

='2023'

=YEAR(TODAY())

=Date(Date#('2022', 'YYYY'))

If I don't use the Year column, and I used other filter such as Department, it works fine. What is the issue here? Thanks

[Or]

Yearname(Today()) or something of that nature should be the right direction if your Year field is a date rather than a number.