DataGrid column datetime filter

Radzen Studio Blazor Server
1

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

image
image.png421ร—577 8.78 KB

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

2

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

3

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
4

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:

image
image.png1920ร—1080 64.6 KB

We will correct the demo.

5

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.

6 
<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;
    ...
}
7

Funciona muy bien. Gracias.

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