[DataGrid] Docs doesn't mention explicitly that date column requires Date object

[tielushko]

Duplicates

• I have searched the existing issues

Latest version

• I have tested the latest version

Steps to reproduce 🕹

Link to live example: https://codesandbox.io/s/filter-before-date-error-6mccmv?file=/Demo.tsx

Steps:

1. Hit filter button in toolbar.
2. Create a filter on column 'blah' type "is before" and type "05/01/2023"
3. Noticed the value.getTime is not a function error in the console.
4. Trying any different filter will not cause the issue to trigger.

Current behavior 😯

Cannot apply filter type "is before" on the timestamp date column.
Also seeing issue with timezone conversion when using "is" filter.

Expected behavior 🤔

I expect the "is before" to work and not throw such error.

Context 🔦

I am attempting to filter the date column. I tried to debug this a little bit and noticed how there's a different filter call for is before filter type in gridFilterOperations.ts type. gridDateOperators variable has an additional parameter in the before type that could be causing the trouble.

Your environment 🌎

npx @mui/envinfo

  Don't forget to mention which browser you used.
  Output from `npx @mui/envinfo` goes here.

Order ID or Support key 💳 (optional)

62502

[romgrk]

The date type requires Date objects: https://codesandbox.io/s/filter-before-date-error-forked-q4tlfk?file=/Demo.tsx

In the doc we seem to mention that column types need a specific type but I don't see it listed which column type takes which value type.

https://mui.com/x/react-data-grid/column-definition/#converting-types

[tielushko]

@romgrk Thank you for your quick response. My next question however, when these timestamps are converted to date objects and formatted to be YYYY-mm-DD, it appears that the 'is' filter type is accounting for the local time zone instead of considering the time in UTC.

For example, filtering on 04/27/2023 will produce no results, but filtering on 04/26/2023 will produce all the values for 04/27/2023.

Is there a way to apply the filter in UTC? Thank you!

[romgrk]

See #8855 for the UTC question. If you need more details ask there.