title: How can I remove the Status = Pending with the Date of less than the currentdate in a select statement
body: <p>How can I remove the Status = Pending with the Date of less than the currentdate in my query... This should be a select statement</p>
  
  <pre><code>Status Date
  Pending 9/5/2014  
  Pending 9/30/2014
  Complete 8/28/2014
  Error 8/20/2014
  </code></pre>