Home / Sharepoint 2010 / SharePoint Calculated Column – how to work around

SharePoint Calculated Column – how to work around

Q: I work in Communications and we collect the news related to our department and send it out by email twice daily, once in the morning and once in the afternoon. I have set up a SharePoint library to group by Date, so it groups uploaded files by the date they were added, which is great. I was wondering if I could group the files under these dates by morning and afternoon (ie. before 12:00 and after 12:00) so by the time that they were added, so that they correspond with our morning and afternoon news alerts?

calculated fieldThats possible:
create a new SharePoint calculated column in the list/library. In the calculated field copy and paste between the quotes “=IF(HOUR(Modified)>12,”PM”,”AM”)”
Save.

Go to view and and group by date and second by this calculated field. This solutions is posted on the below forum by me and wanted to add it to by blog for further reference:
http://sharepoint.stackexchange.com/questions/141988/grouping-columns-by-date-and-time/141997#141997

Detailed help in these links: https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx

About Venu Madhav

Check Also

PowerShell Script – list all SharePoint group members

A quick script to query  site collections in a web application for SharePoint group and ...

Leave a Reply