title: SQL Query Help - Selecting between startdate and enddate
body: <p>Need help with three sql query's. </p>
  
  <p>Our database holds the following information - Samples given</p>
  
  <pre><code>unique id -- package            -- startdate  -- enddate
  1         -- Holiday Package 1  -- 05-08-2012 -- 05-25-2012
  2         -- Holiday Package 2  -- 05-13-2012 -- 06-26-2012
  3         -- Holiday Package 3  -- 05-14-2012 -- 05-14-2012
  4         -- Holiday Package 4  -- 05-15-2012 -- 05-16-2012
  5         -- Holiday Package 5  -- 05-21-2012 -- 07-16-2012
  </code></pre>
  
  <p>Query 1 - given today's date(05-11-2012) return all packages that lie within the next seven days</p>
  
  <p>So for example if the date is 05-11-2012 i'd want the query to return all packages that are currently running for the next 7 seven days. So in the example this would be everything except Holiday Package 5.</p>
  
  <p>Query 2 - Given today's date return all packages that lie within 14 days but not seven days</p>
  
  <p>Result - Package 5 Only</p>
  
  <p>Query 3 - Given today's date return all packages that lie within both 7 and 14 days but not either/or</p>
  
  <p>Result - None</p>
  
  <p>Thanks for any help.</p>