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 ?
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 ?
Create a calculated column named Year with this formula inside
Set decimal place setting to 0 and filter for this column
See this MSDN page for more details on calculated column