Radzen DataGrid - Filtering - Advanced Mode - Date #829

Closed
opened 2026-01-29 17:45:01 +00:00 by claunia · 2 comments
Owner

Originally created by @DanRogers99 on GitHub (Apr 27, 2023).

If a Radzen DataGrid DateTime FormatString is set to "{0:d}", the filters will only display dates, This is perfect.

However when you open up the date picker it is possible to set the time. If this is then set to anything other then 0:00 any matching records from that day will not be found.

Is there a way we could set the DatePicker to ShowTime to false as a property of the RadzenDataGridColumn, or auto-disable if the format string is a date only?

Query working as expected:
image

Undesired behavior:
image

Originally created by @DanRogers99 on GitHub (Apr 27, 2023). If a Radzen DataGrid DateTime FormatString is set to "{0:d}", the filters will only display dates, This is perfect. However when you open up the date picker it is possible to set the time. If this is then set to anything other then 0:00 any matching records from that day will not be found. Is there a way we could set the DatePicker to ShowTime to false as a property of the RadzenDataGridColumn, or auto-disable if the format string is a date only? Query working as expected: ![image](https://user-images.githubusercontent.com/33861884/234895841-5b8c4d4f-95c9-431c-8869-61bb75831b89.png) Undesired behavior: ![image](https://user-images.githubusercontent.com/33861884/234895918-91a54364-b4d9-41ee-aa4d-f87b1ee51942.png)
Author
Owner

@enchev commented on GitHub (Apr 27, 2023):

Filtering works with DateTime - it will always have time no matter if time part of the picker is visible or not. This can be easily checked in the source code, please use our forum in the future to post your questions.

@enchev commented on GitHub (Apr 27, 2023): Filtering works with DateTime - it will always have time no matter if time part of the picker is visible or not. This can be easily checked in the source code, please use our forum in the future to post your questions.
Author
Owner

@DanRogers99 commented on GitHub (Apr 28, 2023):

Sorry @enchev, maybe my message wasn't very clear.

My feature request is if the advanced filter mode is used on a date-only field - ie format string set to "{0:d}" I want a way to disable the time selector from showing within the calendar.

234895841-5b8c4d4f-95c9-431c-8869-61bb75831b89

Thank you

@DanRogers99 commented on GitHub (Apr 28, 2023): Sorry @enchev, maybe my message wasn't very clear. My feature request is if the advanced filter mode is used on a date-only field - ie format string set to "{0:d}" I want a way to disable the time selector from showing within the calendar. ![234895841-5b8c4d4f-95c9-431c-8869-61bb75831b89](https://user-images.githubusercontent.com/33861884/235086022-89db0ffe-4102-423f-bc3c-d6fb5cafd622.png) Thank you
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/radzen-blazor#829