Using Filter option to filter based on year


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?

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


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

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.