Skip to content

[data grid] column type "dateTime" and built in operator after is not filtering properly. #19974

@shrewdact

Description

@shrewdact

Steps to reproduce

Steps:

  1. Open this link to live example: (required)

  2. Visit https://v6.mui.com/x/react-data-grid/filtering/

  3. Make visible "Updated on" by Column selector panel

Image
  1. Sort "Updated on" by descending
Image
  1. Apply filter with same date, hour, minutes as the top sorted row
Image

Current behavior

Rows that match the same hour and minute are excluded from the results.

I’ve attached a screen recording to illustrate the issue more clearly.

Thanks for taking a look!

Expected behavior

Rows with the same hour and minute as the filter value should be visible in the filtered results.

Context

No response

Your environment

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

System:
    OS: macOS 26.0
  Binaries:
    Node: 22.16.0 - /Users/juseonghyeok/.local/state/fnm_multishells/3161_1760577476637/bin/node
    npm: 10.9.2 - /Users/juseonghyeok/.local/state/fnm_multishells/3161_1760577476637/bin/npm
    pnpm: 10.13.1 - /Users/juseonghyeok/.local/state/fnm_multishells/3161_1760577476637/bin/pnpm (we use pnpm)
  Browsers:
    Chrome: 141.0.7390.108
  npmPackages:
    @emotion/react: ^11.11.4 => 11.14.0 
    @emotion/styled: ^11.11.0 => 11.14.1 
    @mui/lab: ^5.0.0-alpha.140 => 5.0.0-alpha.177 
    @mui/material: ^5.15.14 => 5.18.0 
    @mui/x-data-grid-premium: ^6.19.4 => 6.19.4 
    @mui/x-date-pickers: ^6.19.4 => 6.19.4 
    @mui/x-license-pro: ^6.10.2 => 6.10.2 
    @mui/x-tree-view: ^6.0.0-alpha.1 => 6.17.0 
    @types/react: ^18.2.14 => 18.3.24 
    react: ^18.2.0 => 18.3.1 
    react-dom: ^18.2.0 => 18.3.1 
    typescript: ^5.0.2 => 5.9.2 

Search keywords: "after" filedOperator on type of dateTime column incorrect comparison

Metadata

Metadata

Assignees

Labels

plan: PremiumImpact at least one Premium user.scope: data gridChanges related to the data grid.support: premium standardSupport request from a Premium standard plan user. https://mui.com/legal/technical-support-sla.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions