title: What is the correct expression to use in order to format a date from "yyyyMMdd" to "M/d/yyyy" in SQL Server Reporting Services?
body: <p>I get dates in my dataset in the form "yyyyMMdd" (ie 20080228 means Feb 28, 2008)</p>
  
  <p>I need to convert these to "M/d/yyyy"</p>
  
  <p>Examples:</p>
  
  <pre><code>20080228 = 2/28/2008
  20080101 = 1/1/2008
  20081001 = 10/1/2008
  20081212 = 12/12/2008
  </code></pre>
  
  <p>what is the correct expression to handle this?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>The expression that I used (ORDDTE is in the "yyyyMMdd" format and I have a switch for spanish or english date format):</p>
  
  <pre><code>=CDate(Mid(First(Fields!ORDDTE.Value, "ReturnTagHeader").ToString(), 5, 2) + "/" + Right(First(Fields!ORDDTE.Value, "ReturnTagHeader").ToString(), 2) + "/" + Left(First(Fields!ORDDTE.Value, "ReturnTagHeader").ToString(), 4)).ToString(IIf(Parameters!Language.Value = "ES", "d/M/yyyy", "M/d/yyyy"))
  </code></pre>