Year information from date field filter

Is it possible to use only a part from a information from a field filter?

My case: I want to use only the year information from the date filter:


Hi @Helena
No and yes. You don't control Field Filters - Metabase controls the code for that.
Please read this:

Your example should probably just use a Number filter instead.
Alternatively, you can use a sub-select:
WHERE YEAR = (select DATE_FORMAT(date_column, "%y") from table where {{FULL_DATE}} limit 1)