In this post we will discuss how to display items group by Year and Month from the Created field in SharePoint 2013.
Also check out:
Here the requirement is the items should show items based on Year and Month in descending order. In the document library created two columns, one for Year and one for Month.
For Year the formula will be:
=TEXT(Created,"yyyy") and it should like below:
For Month column, the formula will look like below:
=TEXT(Created,"mm")&" "&TEXT(Created,"mmmm") and it should be shown like below:
Now create the view and in the View the Group By condition should be look like below:
Finally it will look like below: