title: What is the SSRS expression for end day of week?
body: <p>I have the following MSSQL query to return the ending day of the week in MSSQL: </p>
  
  <pre><code>SELECT DateAdd(Day, 0 - DatePart(Weekday, GetDate()), GetDate());
  </code></pre>
  
  <p>I played around with the <code>=DateAdd</code> function, but it keeps throwing me an error for the Day parameter. Also, when I used <code>DateInterval.Day</code>... I get the same error.</p>
  
  <p>However, when I try placing that query into an SSRS expression, it throws me an error. Does anyone know the direct conversion for that query above in SSRS?</p>