[data grid] Sort by time order incorrect

[xingyaoc-1999]

Steps to reproduce

Link to live example: (required)

Steps:
1.create two data with time as 2024-10-23T07:28:44.436Z and 2024-10-09T06:04:46.000Z
2.order the data by time
3. find the order is wrong

Current behavior

No response

Expected behavior

No response

Context

No response

Your environment

npx @mui/envinfo

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

Search keywords: order time

[KenanYusuf]

Hi @xingyaoc-1999 please can you provide a reproduction? You can fork a CodeSandbox/StackBlitz demo from the demos on the docs https://mui.com/x/react-data-grid/sorting/

[xingyaoc-1999]

I found the problem. It is not possible to convert a date to a string in the valueGetter, it needs to be done in the valueFormatter.

[github-actions]

This issue has been closed. If you have a similar problem but not exactly the same, please open a new issue.
Now, if you have additional information related to this issue or things that could help future readers, feel free to leave a comment.

Note

@xingyaoc-1999 How did we do? Your experience with our support team matters to us. If you have a moment, please share your thoughts in this short Support Satisfaction survey.