title: Cannot get 180 day sql date to work
body: <pre><code>SELECT CTT.BAN, `Company`, `CID`, `FName`, `MInit`, 
     `LName`, `OName`, `Address`, `City`, `State`, 
     `PostalCode`, `ActiveDate`, `ClosedDate`, `Draft`, 
     `Credit`, `BillingCycle`, `BillingFreq`, `Suspended`, 
     `Paperless` , BTT.Bal 
  FROM CustomerT CTT
    JOIN BalanceT BTT
  ON (CTT.BAN = BTT.BAN)
  WHERE  `Paperless` !=  '1'
     AND `BankDraft` != -1
     AND `CreditCard` != -1
     AND (`BillingCycle` = '1' OR `BillingCycle` = '0')
     AND `Bal` &gt; 2 
     AND (`AccountClosedDate` IS NULL OR 
              DATE(`AccountClosedDate`) &gt;= (NOW() - INTERVAL 180 DAY)  )
  </code></pre>
  
  <p>Everything works with this query but the 180 date peice i have tried several things from this site, with no luck. I need to include into the table only the last 6 months closed acount.</p>