title: SQL Server Query Last 6 Months
body: <p>Every time I update the data I want it to only reflect the last 6 months of data. Below is my current query. Can someone assist me with this?</p>
  
  <pre><code>SELECT ar.[Report Date]
  ,ar.Facility
  ,SUM (ar.[0-30]) AS [0-30]
  ,SUM (ar.[31-60]) AS [31-60]
  ,SUM (ar.[61-90]) AS [61-90]
  ,SUM (ar.[91-120]) AS [91-120] 
  ,SUM (ar.[120+]) AS [120+]
  FROM DBO.ARByPayer AS ar
  WHERE ar.[Current Financial Class] &lt;&gt; 'Lien'
  GROUP BY ar.Facility, ar.[Report Date]
  ORDER BY ar. [Report Date]
  </code></pre>