LinkedIn

Friday, June 18, 2010

Calculated Column to Display Year in Sharepoint List


=TEXT([Due Date],"yyyy")


at
Labels: , , , , ,

1 comment:

  1. AnonymousMay 6, 2011 at 6:55 PM

    Thanks for this.

    Also had some luck with

    =TEXT(YEAR([Report Date]),"000")

    ReplyDelete

Subscribe to: Post Comments (Atom)