Wednesday, June 29, 2011

Extracting Month and Year from a Date and Time Field

I created a series of of document libraries in Sharepoint 2010 to archive minutes from meetings. I wanted to create a view that grouped the minutes by year and month, but I only wanted users to enter the date of the meeting. I figured out how to extract the month and year from the date column and display those as separate columns.