title: Get Year of CreatedBy date in a calculated column
body: <p>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.</p>
  
  <p>Any ideas how I can do this? 
  =YEAR([Created]) does not seem to work as expected.</p>
  
  <p>Thanks
  Nav</p>