title: Get the item which date is closest to now
body: <p>In my database I have a list of items with the following property:</p>
  
  <pre><code>public System.DateTime CARD_OF_DAY_DATE_CREATED { get; set; }
  </code></pre>
  
  <p>I need to get the item which <code>CARD_OF_DAY_DATE_CREATED</code> is the closest to <code>DateTime.Now</code> using c#. I could do massive for/foreach loops, but I was wondering if there was a good, efficient way to do it with anything?</p>
  
  <p><strong>Note:</strong> The <code>CARD_OF_DAY_DATE_CREATED</code> field needs only to be checked <strong>forward</strong>, meaning that checking if the <code>CARD_OF_DAY_DATE_CREATED</code> is yesterday would be non-relevant because those items won't be in the list.</p>