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