Linq DateTime Operations Comparison
<p>So I have this statement</p>

<pre><code>SearchResults = (from s in dbContext.tbl_ShippingProgram
                 where s.eta_date.Date &gt; DateTime.Now.Date.AddMonths(-TimePeriod.Value)
                 select s).ToList();
</code></pre>

<p>Where SearchResults is defined as </p>

<pre><code>public List&lt;tbl_ShippingProgram&gt; SearchResults { get; set; }
</code></pre>

<p>And where TimePeriod.Value is a int</p>

<p>I'm having difficulties figuring out why this doesn't work, there's nothing wrong the with just selecting all values since</p>

<pre><code>SearchResults = (from s in dbContext.tbl_ShippingProgram
                 select s).ToList();
</code></pre>

<p>Works perfectly fine. Any and all help is appreciated &lt;3</p>

<p>EDIT
 - The issue is that it's not returning anything where it definately should be, checked the values in the db and the calculated DateTime.Now value and it should be returning something
<a href="https://i.stack.imgur.com/EmhgO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EmhgO.png" alt="Some Example rows that should be returning, the eta date is the first date field"></a></p>