title: C# - Return record which has the lowest PayDate but also the highest ReconciliationDate
body: <p>So I need to pull the record which matches the following criteria:</p>
  
  <p>A record which has the lowest PayDate but also the highest ReconciliationDate. 
  An example of records can be seen like this</p>
  
  <pre><code>public class Data {
      public string Name { get; set; }
      public DateTime PayDate { get; set; }
      public DateTime ReconciliationDate { get; set; }
  }
  
  --------------------------------------------------
  | Name   | PayDate    | ReconciliationDate       |
  --------------------------------------------------
  | Andrew | 11/14/2018 | 07/01/2018               |
  --------------------------------------------------
  | Andrew | 10/14/2018 | 06/01/2018               |
  --------------------------------------------------
  | Andrew | 05/14/2018 | 08/01/2018               |
  --------------------------------------------------
  | Andrew | 05/14/2018 | 03/01/2018               |
  --------------------------------------------------
  | Andrew | 05/14/2018 | 10/01/2018               |
  </code></pre>
  
  <p>So the correct record to be returned would be #5</p>
  
  <p>How can I achieve this using C#?</p>
  
  <p>I have this so far:</p>
  
  <pre><code>    var recordsNextCouponPaymentAfterLastOfMonth = externalInterestForSecurity.Where(aExternalRecord =&gt; aExternalRecord.PayDate &gt; priorMonthEnd);
  </code></pre>