CODEWITHSUNDEEP
c#entity-frameworklinq
John S
John S

Reputation: 8349

Linq Query with date range not returning any records?

I've trying to create a Linq to Entities query that selects records between two dates. 

TimeCards.Where(t => t.StartTime >= DbFunctions.CreateDateTime(2015,1,31,null,null,null) && t.EndTime < DbFunctions.CreateDateTime(2017,2,14,null,null,null))

This is my dataset that I am expecting to have returned

ID      StartTime               EndTime    
1165    2016-02-01 00:15:00.000 2016-02-01 17:00:00.000
1166    2016-02-02 00:15:00.000 2016-02-02 17:00:00.000
1167    2016-02-03 00:15:00.000 2016-02-03 17:00:00.000

But my results are coming back as 0 records.

Any ideas why that is?

Upvotes: 2

Views: 661

Answers (1)

Smit Patel
Smit Patel

Reputation: 3267

Try using this code, It will give you 3 records as per your need.

DateTime startDate = new DateTime(2015, 1, 31, 0, 0, 0);
DateTime endDate = new DateTime(2017, 2, 14, 0, 0, 0);
List<anyTable> listOfRec = dbContext.anyTable.Where(row => row.StartDate > startDate && row.EndDate < endDate).ToList();

Upvotes: 1

Related Questions