SharePoint filter on year

149 views Asked by At

currently i have a date in SharePoint, but I want to filter on Year.

What I have is that I can filter on all documents from 25-11-2014. But I have also documents from 20-11-2014. I want to filter only on year, somebody know how I can do that ?

1

There are 1 answers

2
Max On

Create a calculated column named Year with this formula inside

=YEAR([ColumnName])

Set decimal place setting to 0 and filter for this column

See this MSDN page for more details on calculated column