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?
Best answer by kuovonne
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})
+29Yes, 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.