title: Using AS400 date in SSRS Report
body: <p>Running a SELECT against the AS400 using the IBMDA400 OleDb provider appears to return dates as string values, SSRS just laughs at you when you try and apply a date format to the field. I've tried a simple CAST in the SELECT to no avail.</p>
  
  <p>How can I get an actual DBTYPE_DBDATE struct back from the iSeries OleDb provider?</p>
  
  <p>I should mention that the dates in question are all being returned by a UDF with a type of DATE. IBM appears to map DATE type into a DBTYPE_STR OleDb type.</p>