title: Not getting Record Between two dates
body: <p>I want to get rows between 2 dates</p>
  
  <p>Here is the query:</p>
  
  <pre><code>select 
      distinct Convert(varchar(09), [DateTime], 103)
  from 
      StudentAttendance_FK 
  where 
      LecturerID = 5033 and 
      CourseID = 1004 and 
      SubjectID = 120 and 
      [DateTime] Between '3/8/2012' and '3/11/2012'
  </code></pre>
  
  <p>Format (MM/DD/YYYY)</p>
  
  <p>Sample values</p>
  
  <pre><code>3/8/2012 11:40:46 PM
  3/8/2012 11:40:46 PM
  3/9/2012 11:57:55 AM
  3/9/2012 10:48:02 PM
  3/10/2012 11:57:20 PM
  </code></pre>
  
  <p>The query isn't returning any rows between these two dates. Any changes in this query?</p>
  
  <p>thanks you</p>
  
  <p>Ajay.</p>