title: Selecting transactions using date
body: <p>i'm trying to select transactions for the past ten days using </p>
  
  <pre><code>where transaction.date &gt; date(now() - interval '10 days')
  </code></pre>
  
  <p>now after i executed this, my result only brings me transaction where the date is ten days before the current date. i'm not getting results for any transactions for the past nine days.</p>