title: Subtract months from current date sql
body: <p>I am trying to substract dates from today (Get a 1 month ago till forever report). So far I've tried </p>
  
  <pre><code>DATE_SUB(NOW(), INTERVAL 1 MONTH) 
  </code></pre>
  
  <p>Here is the context:</p>
  
  <pre><code>SELECT contracts.currency , ROUND(SUM( 
      CASE
          WHEN contracts.currency = 'USD' THEN contracts.value*550
          WHEN contracts.currency = 'UF' THEN contracts.value*22000
          ELSE contracts.value
      END),2)
      AS real_value
  FROM contracts
  WHERE currency IN ('USD','UF','CLP') AND date &gt;=DATE_SUB(NOW(), INTERVAL 1 MONTH)
  GROUP BY currency 
  ORDER BY currency ASC
  </code></pre>