title: System date is displaying when the value is NULL in date field in SSRS report?
body: <p>Below is my SQL query used in SSRS report</p>
  
  <pre><code>SELECT Claimname,CONVERT(VARCHAR,ClaimResponsedate,101) FROM Claim WHERE DataSourceID = 100011
  </code></pre>
  
  <p>From the above query 'ClaimResponsedate' may get NULL values but in SSRS report for this field displaying 1/1/1990 when the value comes as NULL.</p>
  
  <p>I need to display empty value in report if the date value is NULL.</p>
  
  <p>I tried below code to avoid but it is not working</p>
  
  <pre><code>=IIF(IsNothing(Fields!ClaimResponsedate.Value),"",Fields!ClaimResponsedate.Value)
  OR
  =IIF(Len(Fields!ClaimResponsedate)=0,"",Fields!ClaimResponsedate.value)
  </code></pre>
  
  <p>So please help me to achieve this i.e. display empty value in report if the date value is NULL</p>
  
  <p>Thanks in advance</p>