Filter Between 2 date in ASP.NET MVC

Question

i want to filter or search between 2 date i write this code , but when i run the application the data which in the table not show what is the wrong ?

This is my controller :

    public ActionResult Index(DateTime? start, DateTime? end)
    {
        var ExpenseDetails = _context.ExpenseDetails.Include(s => s.expenses).Where(t => t.DateExpense >= start && t.DateExpense <= end).ToList();

        return View(ExpenseDetails);
    }

and this is View :

@using (Html.BeginForm())
{
        <div>
            <span>Start Date :</span> <input type="date" name="start" />
            <span>End Date :</span> <input type="date" name="end" />
            <input type="submit" value="Get Records Between Dates" />
        </div>
        <table>
        @foreach (var item in Model)
        {
            <tbody>
               <tr>
                    <td>
                         @Html.DisplayFor(modelItem => item.expenses.Expenses_Type)
                    </td>
                    <td>
                        @Html.DisplayFor(modelItem => item.DateExpense)
                    </td>
                    <td>
                        @Html.DisplayFor(modelItem => item.Amount)
                    </td>                           
            </tbody>
         }
        </table>

}

enter image description here

Thank you

Answer 1

You need to confirm the followings when you are dealing with dates:

• Compare without the time part if not required. Example is here
• Compare DateTime in a common format. For example input DateTime and server DateTime can be on different timezone. Convert them both to Utc before the comparison
• You can compare the year and months individually [not recommended]