Displaying only Year in SharePoint Calculated Column

By Namwar Rizvi - Last updated: Thursday, November 26, 2009 - Save & Share - Leave a Comment

I wanted to display just the year of a DateTime column of SharePoint. I created a calculated column and set the formula to Year([MyDateTimeColumn]). The result I got was 2,009 ; 2,008 etc. which offcourse incorrect for year. After searching through internet, I found a good article solved my problem.

The correct formula is TEXT(YEAR([MyDateTimeColumn]),”000″)

Posted in Architecture, Customization, Solutions, Tips • Tags: , , , Top Of Page

Write a comment