title: DateAdd() returns faulty Date in SQL Server Reporting Services
body: <p>I have a report that takes a date as a parameter.</p>
  
  <p>If I use <code>=Parameters!Date.Value</code>, the report runs fine. </p>
  
  <p>However, if I use <code>=DateAdd("d", 1, Parameters!Date.Value)</code>, the report is left blank, even though the formats are exactly the same:<img src="https://i.stack.imgur.com/eDhOb.png" alt="screenshot of what this looks like">. (Note: it simply cannot run. It's not that there are no values to return as the field names don't return either.)</p>
  
  <hr>
  
  <p>I have also tried  <code>=DateAdd(DateInterval.Date, 1, Parameters!Date.Value)</code></p>
  
  <p><code>=DateAdd("d", 1, Parameters!Date.Value)</code> </p>
  
  <p><code>=DateValue(FormatDateTime(DateAdd("d", 1, Parameters!Date.Value), DateFormat.ShortDate ))</code> and many variations thereof but I can't seem to crack it!</p>
  
  <hr>
  
  <h2>Update</h2>
  
  <p>If I use <code>DateInterval.Month</code> instead of <code>DateInterval.Day</code> then the date is still incremented as desired (12/22/2010) but the table shows up! Interesting how my local settings are <em>dd-mm-yyyy</em> and these dates are <em>mm-dd-yyyy</em>.</p>