Calculation in a filter pane

KevSan — Wed, 26 Jan 2022 16:17:36 GMT

Hi everyone,

I would like to filter my year by using a formula in the filter pane.

I tried different formulas but no one is working.

CalendarYear = Year(Date(Today())

Do you know how I can do it?

Have a nice evening.

Re: Calculation in a filter pane

joaopaulo_delco — Wed, 26 Jan 2022 17:46:15 GMT

You can try this:

=CalendarYear=Year(Today(1))