Grid datetime filter not working

Hi,

I'm using kendo grid to display data that come from OData service (build in asp net core).

Date filter is not working for datetime columns.

The issue is related to time value that is passed as filter (an example down below).

Is there a way to avoid time in filter?

Thanks

Maurizio

 

NO RESULTS

/api/P6activity?$count=true&$filter=(finishDate eq 2020-01-23T00:00:00.000Z and projectId eq 'H171P')

CORRECT RESULTS

/api/P6activity?$count=true&$filter=(finishDate eq 2020-01-23 and projectId eq 'H171P')

 

{
  "@odata.context": "http://localhost:11111/api/$metadata#P6activity",
  "@odata.count": 3,
  "value": [
    {
      "id": 566,
      "projectId": "H171P",
      "activityId": "M194",
      "name": "Demi Mechanical Document",
      "startDate": "2019-11-15T13:00:00+01:00",
      "finishDate": "2020-01-23T17:00:00+01:00",
      "sapControlKey": null,
      "sapTransfer": false,
      "sapMaterialGroup": null,
      "sapPurchGroup": null,
      "sapOdA": null
    },
    {
      "id": 739,
      "projectId": "H171P",
      "activityId": "Q176",
      "name": "MEP Works Order",
      "startDate": "2019-12-23T08:00:00+01:00",
      "finishDate": "2020-01-23T17:00:00+01:00",
      "sapControlKey": null,
      "sapTransfer": false,
      "sapMaterialGroup": "Z003",
      "sapPurchGroup": null,
      "sapOdA": "0260"
    },
    {
      "id": 970,
      "projectId": "H171P",
      "activityId": "U080",
      "name": "Thermal Cycle Sampling System Mechanical Drawings",
      "startDate": "2019-12-16T08:00:00+01:00",
      "finishDate": "2020-01-23T17:00:00+01:00",
      "sapControlKey": null,
      "sapTransfer": false,
      "sapMaterialGroup": null,
      "sapPurchGroup": null,
      "sapOdA": null
    }
  ]
}