title: SSRS Report Shows #Error on DateTime Field
body: <p>I have a query that shows DateTime field with the name of “<code>PostedOn</code>” in SSRS.
  The Problem is that when I view my report using ASP.Net, report shows #Error only on PostedOn Field.
  But when I view my report in Designer View than it shows the PostedOn Date correctly.
  If I use </p>
  
  <pre><code>= Fields!PostedOn.Value
  </code></pre>
  
  <p>the direct value, it shows the PostedOn Column empty on SSRS.
  And if I use </p>
  
  <pre><code>= CDate(Fields!PostedOn.Value).ToShortDateString() 
  </code></pre>
  
  <p>than it particularly bounces back with the #<code>Error</code>.
  Designer shows the correct Date
      <code>e.g. 08/06/2012.</code></p>
  
  <p>When I view this report from ASP.Net Application. It Shows #<code>Error</code>.
  I have checked it with </p>
  
  <pre><code>=Iif(IsNothing(Fields!PostedOn.Value),"",
  CDate(Fields!PostedOn.Value).ToShortDateString())' 
  </code></pre>
  
  <p>as well but no luck so far. #<code>Error</code> is shown on the Report.
  Please help me on this.
  Thanks in advance.</p>