Filtering Using a Lookup Field

[Wes_McDermott]

Hello,

I have a table that has a Date Field. I wanted to use the filter option for a table to filter date records for a specific year such as only show dates that are 2020. With a date field, I don’t have an option to choose a date for a year. Is it possible to use a formula in this Filter section?

[kuovonne · Accepted solution]

Yes, you can create a formula field, and then filter based on that formula field. (You cannot enter the formula directly in the filter.)
Here is one formula for getting just the year of a date field

YEAR({date})

[Wes_McDermott]

Thank you very much! That is exactly what I needed.