5

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

jonazu
  • 380
  • 2
  • 12
van
  • 9,159
  • 19
  • 60
  • 93
  • 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 – van Nov 12 '10 at 17:14

3 Answers3

6

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

alt text

Marek Grzenkowicz
  • 17,024
  • 9
  • 81
  • 111
5

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

Amit Dubey
  • 51
  • 1
  • 1
  • 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. – jonazu Jun 03 '14 at 07:06
2

Another solutionn = TEXT (created,"yyyy')

XristosK
  • 266
  • 4
  • 16