title: Linq Select all records newer than a specific date
body: <p>I have a simple query where I want to get all data where a particular date is newer than 6 years ago.</p>
  
  <p>My code looks like this:</p>
  
  <pre><code>var dt = DateTime.Today.AddYears(-6);
  return _context.ChildInfo.Where(c =&gt; c.ChildDob &gt; dt );
  </code></pre>
  
  <p>But this is returning all records not just ones that are newer than 6 years ago from today. What am I doing wrong ?</p>
  
  <p>Edit:</p>
  
  <p>childdob definition</p>
  
  <pre><code>public partial class ChildInfo
  {
      public DateTime? ChildDob { get; set; }
  }
  </code></pre>