I want to get the today entered records using LINQ to SQL. I wrote the below code but it is returning previous date records also.

DateTime todaysDate = DateTime.Now;
DateTime yesterdaysDate = DateTime.Now.AddDays(-1);

var result = (from a in cxt.visitor.OrderByDescending(n => n.singin)
              where (a.singin > yesterdaysDate && a.singin <= todaysDate)
              select new {a.visitorid, a.visitorname, a.visitingperson, a.phonenumber, a.reasonforvisit, a.signature, a.singin });

Can you please tell me how to get the today entered records only using LINQ to SQL?

c# linq-to-sql
Edit
Report