Skip to main content

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?

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

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

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

Reply


Terms & Conditions