Sharepoint: Group a list by month

By peter.stilgoe









You have a SharePoint list that contains a date column, you want to create a view that groups all the items by the dates month only.

To do this create a ‘Calculated Column’ and use the following formula:

=TEXT(Date,”yyyy – “)&TEXT(Date,”mm”)&TEXT(Date,” (mmmm”)&TEXT(Date,” yyyy)”)

Now by grouping your list by this column, your list will be grouped by the dates month only.

Share


About... peter.stilgoe

peter.stilgoeThis author published 482 posts in this site.
Sharepoint, InfoPath, K2, Nintex, Business Process Mapping, Business Intelligence, Automation, ECM, Document Management, Document Imaging, Internet Marketing & Online Business Consultant Email / MSN: pstilgoe@hotmail.com LinkedIn: Pete Stilgoe - Sharepoint Consultant









Share

FacebookTwitterEmailWindows LiveTechnoratiDeliciousDiggStumbleponMyspaceLikedin

No Comments

(Required)
(Required, will not be published)