title: Check Expiry by comparing date store and current date MVC3 C#
body: <p>I am trying out a linq query check expiry by comparing a saved date and current date in mvc3 controller</p>
  
  <pre><code>[AllowAnonymous]
     public ActionResult _leftHomeAd()
      {    var LhAd = db.Adverts
           .Where(u =&gt; u.ACatId ==1)
           .Where(u =&gt; u.OffDate &lt;= DateTime.Now.Day);
            return PartialView(LhAd);
  </code></pre>
  
  <p>And I get the error that I cannot use &lt;= for system date.  Can someone point me in the right direction so that my query can retrieve only adverts that have not expired.</p>