Select r.Name, r.number from records r where (r.datePurchased BETWEEN '03/03/2012%' AND '05/03/2012%') AND r.Code=4
r.Where( i => i.datePurchased >= new DateTime(2012, 03, 03) && i.datePurchased <= new DateTime(2012, 05, 03) && i.Code == 4) .Select(i => new {i.datePurchased, i.Number});
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)