title: Extract Month/Year from Date in SSRS 2008
body: <p>I am using SQL Server SSRS 2008 version and I need to extract out of a date field, the Month and Year values.  For example from   2013-01-11 21:11:29.340,  I need the report to display “January 2013”</p>
  
  <p>In design view, in the cell where I want the information to display, where the ‘Expression’ option from the pull down menu, I put</p>
  
  <pre><code>= DATENAME(MONTH, DesiredDate) &amp; DATENAME(YEAR, DesiredDate) .
  </code></pre>
  
  <p>And got an error message.</p>
  
  <p>BTW, the ‘DesiredDate’ comes from the SQL code in the Query Designer.</p>