title: How to add date range to this SQL in trac?
body: <p>We have the following query working as expected and have one last thing left in our modification of trac:</p>
  
  <pre><code>SELECT
     p.value AS __color__,
     owner AS __group__,
     id AS ticket,
     severity,
     status,
     priority,
     summary,
     component, 
     milestone, 
     t.type AS type, 
     time AS created, 
     description AS _description, 
     reporter AS _reporter, 
     changetime AS modified, 
     time AS _time,
     reporter AS _reporter 
  FROM 
     ticket t 
     LEFT JOIN enum p 
     ON p.name = t.priority 
        AND p.type = 'priority' 
  WHERE 
     status = 'closed' 
  ORDER BY 
     owner, 
     p.value, 
     t.type, 
     time
  </code></pre>
  
  <p>We need to date range to this to only pull out tickets closed between Aug 5 and Aug 17. We need to be able to edit the query to change the date range as needed as we need a few different date range. Can you please advise how to change the query to have date range between Aug 5 to Aug 17 ?</p>