DataGrid column datetime filter

Hi!
The filter in DataGrid by date does not work correctly.

The table has a column with a date (without time and time zone).
The time in the date is always 00:00:00

I open the filter and select the date I need, but there are already selected hours and minutes. I reset the hours and minutes to zeros, click ok..

image
.. and the filter is set to
image

filter by date does not work as expected

How to specify seconds?
Is it possible to indicate that the filter will be timeless?
Format = 'date' does not help

Thanks for the report! It will be fixed in our upcoming release later today.

After the release, the filter by date generally stopped working: if you select the appropriate date in the filter, then not a single line will remain in the grid.
can you help with this?

https://blazor.radzen.com/datagrid

1 Like

How the grid is bound in your case? What is set as Data? What we've changed is the filter expression for DateTime from Convert.ToDateTime() to DateTime() to support older versions of EF (EF 6.x). Indeed on our demo with SQLite there is a problem at the moment however using MSSQL for example everything should work as expected:

We will correct the demo.

I use web api as the data source, so I’m just working with a list of objects that has a date with a value of January 1, 2019, but when I select this date in the list of results, I don’t see the desired results.

<RadzenGrid TItem="ExchangeRateFullModel"
            FilterCaseSensitivity="FilterCaseSensitivity.CaseInsensitive"
            Data="@rates" 
            AllowFiltering="true"
            AllowSorting="true" 
            PageSize="50" 
            AllowPaging="true">
    <Columns>
        <RadzenGridColumn TItem="ExchangeRateFullModel" Property="@nameof(ExchangeRateFullModel.DateCourseDate)" Title="Дата курса">
            <Template Context="data">
                @(data.DateCourseDate.ToString("dd.MM.yyyy"))
            </Template>
        </RadzenGridColumn>
      .............
    </Columns>
</RadzenGrid>

I use the binding to the field 'DateCourseDate '
DateCourse => 21.11.2019 0:00:00 +03:00
DateCourseDate => 21.11.2019 0:00:00

public class ExchangeRateFullModel
{
    /// <summary>
    /// Date of exchange rate.
    /// </summary>
    public DateTimeOffset DateCourse { get; set; }
    public DateTime DateCourseDate => DateCourse.Date.Date;
    ...
}

Funciona muy bien. Gracias.

Un ejemplo:
....
<RadzenDataGridColumn TItem="Employee" Property="BirthDate" Title="Birth Date" FormatString="{0:d}" Width="160px" />
...