Thursday, June 5, 2014

Get Year from Date column in Calculated column in sharepoint

 calculated formula:

IF([DateComposed]="" , "No Due Date",""&YEAR([DateComposed]))   

(OR)

=IF(DateComposed="","",""&YEAR(DateComposed))    

here : DateComposed is Date column

Refrence:
http://techtrainingnotes.blogspot.in/2012/02/sharepoint-group-by-year-or-month-in.html

No comments:

Post a Comment