title: SQL Server: Getting "before two days" date
body: <p>I have a select, and I need to limit data only for two last days. So today is 24th Aug 2016 so I need to get data for 24th Aug 2016, 23th Aug 2016 and 22th Aug 2016. How can I do that? I suppose I should use DATEADD function, or something similar. It needs to be done dynamicaly. </p>
  
  <p>I need to get something like this:</p>
  
  <pre><code>SELECT * FROM TABLE_NAME WHERE
  DATE = '2016-08-22'
  </code></pre>
  
  <p>The date must be updated each day</p>