Date filtering with "is this year", "is next year", "is last year"

Dear monday.com. When filtering a date field, with “is”, there are some options available like “this month”, "last week,…
I’m missing “last year”, “this year” and “next year”. It’s very useful in Excel and I also need it in Monday for my Dashboard in the Graph widget filter or in views of regular Boards.
Our company is setting KPI’s with annual goals, like probably every company does and therefore we need to have the possibility to apply the calculation of such KPI’s for specific years. Using a static definition like “between” 1.1.2021 and 31.12.2021 is not really great, because after the end of a year, we want the calculation to be dynamically changed to Year n+1 and need to perform the change for each and every view and graph widget.

@Sales

I agree that those filter options would be a good addition.

Until they are available, one option for “advanced” filters is to create a formula column to create the filter values that you want.

For example…

The following formula will return: “Past”, “Last Year”, “This Year”, “Next Year”, or “Future” based on the value of {Date}

SWITCH(
MIN(MAX(YEAR({Date})-YEAR(TODAY()),-2),2), 
-2, "Past",  -1, "Last Year", 0, "This Year", 1, "Next Year", 2, "Future")

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday.com Mirror Columns in Integromat - the Basics
Check out our monday apps, now in beta: The Monday Man Apps

Then you can set the filter to {Filter Formula} contains “This Year” (or whichever).

1 Like