FilterByColumnsAsync does not work for a specific date (Sf produces wrong odata request)

[Heistema]

Hi,

i simply want a column to be filterable by a simple date. An equal would do, but no matter what I do Syncfusion fails to produce the correct request. This is a hughe showstopper.

E.g. when I implement the filter like so:

var someDate = new DateTime(2023, 07, 23, 0, 0, 0, DateTimeKind.Utc);
await _palletGrid.FilterByColumnAsync(nameof(Pallet.CreationDate), "equal", someDate, null, true);

The produced request looks like:
/odata/Pallet?$count=true&$filter=(CreationDate eq 2023-07-23T00:00:00.000Z )&$skip=0&$top=50

Which is wrong, testing agains my odata backend my request should rather look like:

/odata/Pallet?$count=true&$filter=(CreationDate eq 2023-07-23)&$skip=0&$top=50

Does anybody have a workaround or an idea?

[Naveen Palanivel]

Hi Heistema,

Before proceeding further with your requirement kindly share the below details to validate further at our end.

1. Share us the entire Grid code snippet along with mode class
2. Share us if any format is applied for Datecolumn
3. Share us the video demonstration of the issue with elaborately , it will more useful to us.
4. If possible share us a simple issue reproduceable sample with duplicate data.

The above-requested details will be very helpful for us to validate the reported query at our end and provide the solution as early as possible.

Regards,

Naveen Palanivel