title: Querying a table with a date/time filter in SQL Server 2008
body: <p>I have a table in my database. This table is called Order. It has a structure like this</p>
  
  <ul>
  <li>ID</li>
  <li>CustomerID</li>
  <li>OrderDate</li>
  <li>Quantity</li>
  <li>Price</li>
  </ul>
  
  <p>I need to get all of the orders for the past 2 weeks. How do I do that? I don't understand how to work with dates in this manner in SQL.</p>
  
  <p>Thank you!</p>