title: Datatable compute: filtering by date
body: <p>I have a datatable with 2 columns: "amount" and "date"</p>
  
  <p>I want to sum "amount" by month &amp; year.</p>
  
  <p>I am trying this:</p>
  
  <pre><code>_tAmount = myDT.Compute("sum(amount)", "date LIKE '%/" &amp; i &amp; "/" &amp; _year &amp; "'")
  </code></pre>
  
  <p>where:</p>
  
  <ul>
  <li>var <strong>i</strong> equals a nº month ( 1 to 12)</li>
  <li>var <strong>_year</strong> equals nº year (example:
  2011)</li>
  </ul>
  
  <p>But not  displays any results....How I can do it? What is wrong?</p>
  
  <p>I am working with the <em>spanish format</em> (example day/month/year). But I have tried with the <em>english format</em> (month/day/year) and no results too.</p>
  
  <p>This is on VB.NET 2008.</p>