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
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
