Filter between on grid column not working correctly

Hello,

i have a problem with Syncfusion sfgrid :

There a no Between filter on sfgrid with Syncfusion.Blazor.Grids.FilterType.Menu

:

Image_8406_1757405831094

To bypass this issue i use the filter between from Syncfusion.Blazor.Grids.FilterType.Excel

the problem is : if an user put just one date in between Start date parameter , it result an error also it should work naturally like the Greater Than filter if you just fill one input or disable the Submit button and color the input in red with error if it is empty

Image_9943_1757405965944Image_7296_1757405987092

Thank you in advance for you answer


1 Reply

GR Guhanathan Ramanathan Syncfusion Team September 12, 2025 10:57 AM UTC

Hi A,

Greetings from Syncfusion,


When using the "Between" filter in the Grid with FilterType.Excel, the Grid expects two date values from the user to perform the operation correctly. Therefore, it is important to provide both a Start Date and an End Date, as the filter is designed to work within a specific date range.

If only one date is entered—such as just the Start Date—the filter cannot determine the full range and may result in an error. This is expected behavior.

If the user intends to provide only a single date value, alternative operators can be selected from the filter's custom menu (e.g., "Greater Than" or "Less Than"), which work with a single input. To ensure a smooth user experience, it is recommended to either validate both inputs before submission or choose a suitable operator that supports single-date filtering.


Thanks for your Understanding.

Regards,

Guhanathan  



Loader.
Up arrow icon