asp.net core filter by two dates

I am trying to filter results of a query using a StarDate and EndDate. My data is saved in format dd/mm/yyyy hh:mm:ss AM/PM and I want to use only date as parameter for filtering. If I use full date format (3/12/2021 12:41:04 PM) is working very well but I want to be able to use only date. What I have is:

public IList WOMainL { get; set; }
public void OnGet()
{
WOMainL = _context.WOMains.ToList();
}
public void OnPost(DateTime sdate, DateTime edate)
{
WOMainL = _context.WOMains.Where(s => s.CreateDate <= sdate && s.CreateDate >= edate).ToList();
}

"post">
Start Date: "datetime" name="sdate" />
End Date: "datetime" name="edate" />
"submit" value="Submit" class="btn" />
class="row no-gutters mt-2">
class="col-md-1 text-center" style="background-color:firebrick;">
class="text-white pl-2">WO NUmber

class="col-md-2 text-center ml-1" style="background-color:firebrick;">

class="text-white pl-2">Create Date

class="col-md-2 text-center ml-1" style="background-color:firebrick;">

class="text-white pl-2">OrgID

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
```
use date part as below
```
public void OnPost(DateTime sdate, DateTime edate)
        {
           var all = _context.WOMains.ToList();
WOMainL =  all.Where(s => s.CreateDate.Date <= sdate.Date && s.CreateDate.Date >= edate.Date);
        }
Marius Vasile5y ago
It couldn't have been much easier than that. Thank you