Filter a view by the current year

Question

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.

Answer 1

Check this workaround and see if it helps:

SharePoint TODAY field and calculated fields...

I used it once before and it works.

I hope you are aware that calculated columns are calculated when item is updated. So after 31.12. 00:00 your calculated columns will no longer be valid (if items are not updated).

Answer 2

You might need two calculated columns. One which is the jan/1/year and the other which is dec/31/year.

=TEXT(Date,"01/01/yyyy")

=TEXT(Date,"12/31/yyyy")

Then in your filter you can have it setup so that the first column is less than today and the second column is greater than today.

There might be a better way but this was my first thought.

Answer 3

I've achieved it using something like this http://sivanesanb.blogspot.ch/2011/11/how-to-use-filters-in-sharepoint-to.html#!/2011/11/how-to-use-filters-in-sharepoint-to.html

Also did another one for the Quarter using the formula =ROUNDDOWN(((INT(MONTH([Created]))-1)/3),0)+1