Filtering table column by date?

[Breezy]

Hello,

I have a sheet with a large table on it. Is there a way my user can filter a column by year? For example:

Filter less earlier than 2019.

Thank you

[stevejoyce · Accepted solution]

I think the two options would be in the search bar to use either expression:

=year(date) < 2019

or

<1/1/2019

[Breezy]

Hello,

Where do i type that in on my table?

[stevejoyce]

The search icon next to your dimension label in header of table.

[Breezy]

Thanks so much!