title: showing only the year portion of a date
body: <p>I want to change the date field in my sql view so that the date will show only the year. </p>
  
  <p>For example, my date field is the typical '07/01/2011'. I want to be able to have the field that changes only to the year, then another one for month, etc. </p>
  
  <p>Ive tried using   <code>CONVERT (VARCHAR(10), GETDATE(), 101)</code>, but that only shows the current date plus the format (101) isn't right.  </p>