Pfthb

I am filtering records based on Dates using Where clause but it's not working. From and To date is same & one record comes within the same date but that getting eliminates.

todate 11/6/2018 12:00:00 AM //while debugging

if (toDate != "0")

 var todate = DateTime.Parse(toDate).Date;
 query = query.Where(x => x.CreatedDate.Date <= todate);

var homework = query.Select(x => new StudentHomework

 HomeworkId = x.HomeworkID,
 CreatedDate = x.CreatedDate
).OrderByDescending(i => i.CreatedDate).Skip(pageLong * recordLong - recordLong).Take(recordLong);
return homework.Any()
 ? Request.CreateResponse(HttpStatusCode.OK, homework)
 : Request.CreateResponse(HttpStatusCode.NoContent);

From db coming one record to controller while debugging in VS

But query is showing 0 records & in ResulView getting below messages

Message = "The specified type member 'Date' is not supported in LINQ
to Entities. Only initializers, entity members, and entity navigation
properties are supported.

If I remove filter in my mobile app json result coming like this

"HomeworkId": 1400,
"ClassName": "Class 1",
"SectionName": "N/A",
"SubjectName": "Mathematics",
"IsAnswered": false,
"CreatedDate": "2018-11-06T00:00:00",

First of all feeling stupid to wasting time of everyone by asking confusing question. Here the issue was this line's .Date

query = query.Where(x => x.CreatedDate.Date <= todate);

In LINQ to Entities I should not have .Date and it is not allowing throwing Exception. After removing this everything working fine. I have try catch block but control was not jumping to it.