In this post we will discuss how to group a SharePoint document library by year created in SharePoint 2013. This is applicable to both list and document library.
Also check out:
Group By Year:
Open the SharePoint document library and then go to LIBRARY tab and then click on Settings Icon and then Library Settings. Then go to the Columns and click on Create column.
Then give the Column name and then in the Formula box type =Year(Created). Then The data type returned from this formula is: Number as shown in the fig below:
Now go to the Views section and then click on Create View and then Choose Standard View from the view type. This will open the Create View page. Give a name for the view. Then go to the Group By and then First group by the column: select the column name which we have created. It will appear like below:
Then click on OK and now check the view it will appear like below:
Group By Month:
Similarly if you want to do group by based on month wise then while creating the column, in the formula write like below:
And it will appear like below
Group By Year and Month:
In this case create 2 columns one for month and one for year like above. Also use the same formula which we have written above. Now got to the view and then go to the Group By and there give on Year in the first and Month in second like below.
Now it will appear like below: