title: select query between two dates
body: <p>I am trying tomake a select join between two specific dates in the database</p>
  
  <p>This I feelis on the right path but is incorrect</p>
  
  <p>How can I get this to work</p>
  
  <pre><code>SELECT --RTRIM(C.CustomerFirstName) + ' ' + LTRIM(C.CustomerLastName) as CustomerFullName,
         ROW_NUMBER() OVER(ORDER BY CP.ActionDate) AS RowNumber,
         C.CustomerFirstName,
         C.CustomerLastName,
         C.CustomerCompany,
         C.CustomerPosition,
         C.CustomerCountry,
         C.CustomerProvince,
         C.CustomerContact,
         CP.ActionDate,
         CP.ProductCode,
         CP.CustomerEmail
  FROM   tblCustomers C
         JOIN tblCustomerProducts CP
              ON  C.CustomerEmail = CP.CustomerEmail
  
  
       ORDER BY ActionDate DESC
  WHERE CP.ActionDate BETWEEN '1/17/2013' AND '19/12/2012'
  </code></pre>