title: SQL statement to find Min Date
body: <p>I am new to SQL so I am fumbling here a bit.  I have the following table:</p>
  
  <pre><code>Entered             Generalist               Item
  12/31/2012 07:26:50 Tom Smith                RTW/Updates
  12/31/2012 07:30:10 Terrie Bradshaw          Posters
  12/31/2012 07:38:16 Jen Lopez                Client Assistance/Request
  12/31/2012 07:48:00 Tom Smith                RTW/Updates
  12/31/2012 07:50:29 Mike Smith               RTW/Updates
  12/31/2012 07:55:32 Tom Smith                Client Assistance/Request
  </code></pre>
  
  <p>I am trying to find out when was the last time a rep was assigned an item. So I am looking for the Min value on a column. My query would look at Item "RTW/Updates" when was the earlier time entered between a date range and return Tom Smith. For example the user queries, RTW/Update between 12/31/2012 and 1/1/2013 and the answer would be Tom Smith.</p>
  
  <p>This is what I have so far, but have not been able to figure out the between the dates part:</p>
  
  <pre><code>    SELECT MIN(entered), generalist, item
  FROM dataTable
  </code></pre>
  
  <p>That is pretty much it.</p>