You can’t use the “Between” keyword in a LINQ query.
The sample snippet below shows how you translate between two date fields.
DateTime fromDate = DateTime.Now.AddMonths(-3); DateTime endDate = DateTime.Now; //linq query var result = from te in datatable.AsEnumerable() where (te.Field("Month") = fromDate) && (te.Field("Month")