A view I created is supposed to filter by the current year. The formula should compare the current year with a column which only has the year.
I don't know how to always get the current year.
I tried creating a calculated column with this formula "Year([Today])" but sharepoint does not like it.
I tried using this formula "Year(Today)" and the view does not return any items.
How do I compare a column with the current year? I am unable to get the current year.