How to compare dates in LINQ?

.net, linq

Solution

I assume that you're talking about in the where clause. It's basically the same way you would compare two DateTime objects elsewhere.

using (DataContext context = new DataContext()) {
   var query = from t in context.table
               where t.CreateDate.Date < DateTime.Today.AddMonths(-1)
               select t;
}

Problem

I want to check if a given date is more than a month earlier than today's date using LINQ. What is the syntax for this? Thanks in advance.

Original source