title: How to create a kql query between dates
body: <p>I am new to KQL and I am struggling to create a report that shows closed tickets between specific dates.
  I've tried this query but no results:</p>
  
  <pre><code>SELECT COUNT('Tickets.Ticket ID') as closed, 'Tickets.Ticket ID', 'Tickets.Full Name', 
  'Tickets.Subject', 'Tickets.Priority', 'Tickets.Creation Date', 'Tickets.Resolved Date' FROM 'Tickets' 
  WHERE 'Tickets.Is Resolved' = '1' AND 'Tickets.Status' = 'Closed' AND 'Tickets.Resolved Date' = '2020- 
  05-01' and 'Tickets.Department' =  'cloud Services' multigroup BY 'Tickets.Resolved Date':Day, 
  'Tickets.Owner'
  </code></pre>