title: Creating List Webpart: Ordering by Date field and Type
body: <p>I am trying to create a web-part to show items that relate to a certain field and are before an expiration date using a web-part in SharePoint 2007.</p>
  
  <p>The list has a <strong>Title</strong> field, a <strong>URL</strong> field a <strong>Related</strong> field and an <strong>ExpireDate</strong> field.</p>
  
  <p>So the list looks like this:</p>
  
  <pre><code>Title       URL           Related  ExpireDate
  Resolution  http://blah   Service  5/14/2013
  Solution    http://blah2  Records  9/14/2012
  </code></pre>
  
  <p>So if I need the items that are related to service today's date is before the expiration date I want it to display.</p>
  
  <p>Do I need a calculated Column?</p>