How do you filter data using LINQ between two dates...
I tried this code but to no avail:
Dim dtDesde as dateTime = datepickerDesde.Value
Dim dtHasta as dateTime = DatepickerHasta.value
Dim employeeList = From Employee In TimeOneDataContext.Employees Where Employee.RecordDate >= dtDesde.ToShortDatestring And Employee.RecordDate <= dtHasta.ToShortDateString Select Employee
I checked the database and confirmed that there is a Recorddate that is between the above date?
Any idead how to filter dates in LINQ?