Get Year of CreatedBy date in a calculated column

Question

I am trying to create a calculated column in SharePoint 2007. I want it to return the year of the CreatedBy column date and set the day to be 1 and the month to be January the data type returned by the formula is of type Date.

Any ideas how I can do this? =YEAR([Created]) does not seem to work as expected.

Thanks Nav

Lindahl

Thanks Marek question edited to clarify that I want to return the year of the Created column and set the month to January and the Day to 01 – Lindahl

Answer 1

=DATE(YEAR([Created]),1,1)

Lariat

Answer 2

You can simply use =CONCATENATE(YEAR([Created])), it represents the year as plain text

Jehanna

This actually is no solution for the problem (getting a date of 1/1/yyyy) but I think most people just want to have the year in an extra column. Then you should use the formula in this answer. It still works in SharePoint 2013. – Sallyanne

Answer 3

Another solutionn = TEXT (created,"yyyy')

Epistle