Home > SharePoint > Format year without comma in MOSS calculated field

Format year without comma in MOSS calculated field

2011/10/19

Normally when is needed the year of a date , and in my case was needed as a column in a view , the first thing you write is:


But the result is:


It is no so obvious to find , but the correct formula to have the year without the comma is =TEXT(YEAR([Date of editing]),”000″)

The data type is “Single line of text”.

Advertisements
Categories: SharePoint
%d bloggers like this: