title: Pull record with latest date from xml stream
body: <p>I am being provided with an xml stream that is a table of records with a field that represents the effective date for the record.  I need to pull the record with the latest effective date.</p>
  
  <pre><code>&lt;?xml version=1.0?&gt;
  &lt;table&gt;
      &lt;row id=12 employeeId=151&gt;  
          &lt;field id=divisionCode&gt;COA1&lt;/field&gt;  
          &lt;field id=glCode&gt;4330&lt;/field&gt;  
          &lt;field id=payType&gt;FTHR&lt;/field&gt;
          &lt;field id=schedule&gt;9a -7:30p M - F&lt;/field&gt;
          &lt;field id=effectiveDate&gt;2016-10-12&lt;/field&gt;
      &lt;/row&gt;
      &lt;row id=26 employeeId=151&gt;  
          &lt;field id=divisionCode&gt;COA1&lt;/field&gt;  
          &lt;field id=glCode&gt;4330&lt;/field&gt;  
          &lt;field id=payType&gt;FTHR&lt;/field&gt;
          &lt;field id=schedule&gt;7a -3:30p M - F&lt;/field&gt;
          &lt;field id=effectiveDate&gt;2019-01-10&lt;/field&gt;
      &lt;/row&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>I want retrieve all fields of the record with effectiveDate = 2019-01-1.</p>
  
  <p>Thanks!</p>
  
  <p></p>
  
  <p>Language somewhat doesn't matter as I only need the concept, equally versed in C# / VB.NET.</p>
  
  <p>I have tried several things including:</p>
  
  <pre><code>Dim dt As DataTable = New DataTable()
  Dim sr As StringReader = New StringReader(xmlStr)
  Dim ds As DataSet = New DataSet()
  ds.ReadXml(sr)
  dt = ds.Tables(0)
  </code></pre>
  
  <p>Thanks.</p>