title: Equivalent of SQL Between Statement Using Linq or a Lambda expression
body: <p>Don't think this is a repost, difficult to search for the word between because it is used in everything (like searching for AND).</p>
  
  <p>I want to filter a list based on a date range.</p>
  
  <p>I have a list with some dates and I want to filter them by a date range.  Is there a Linq or Lambda equivalent of the <code>between</code> statement in SQL.</p>
  
  <p>For example, the code below will not work in Linqpad (or Visual Studio):</p>
  
  <pre><code>void Main()
  {
      List&lt;ListExample&gt; list = new List&lt;ListExample&gt;();
  
      list.Add(new ListExample("Name1","23 Aug 2010"));
      list.Add(new ListExample("Name2","23 Aug 2009"));
  
      var query = from l in list
          where l.DateValue between "01 Jan 2010" and "01 Jan 2011"
          select l;
  
  }
  
  public class ListExample
  {
  
      public ListExample(string name, string dateValue)
      {
          Name = name;
          DateValue = DateTime.Parse(dateValue);
      }
  
      public string Name{get;set;}
      public DateTime DateValue{get;set;}
  }
  </code></pre>