[data grid] filter not returning correct results

[imharrod]

Steps to reproduce

Link to live example: (required)

Steps:

1. Data contains a field called ScheduledTestDate which is a date field 2.Filter is written as "On or After 05/02/2024" AND second filter "On or Before 08/02/2024" 3.Result is returning rows with ScheduledTestDate of 04/09/2025

Current behavior

The resulting display is not including the correct number of rows

Expected behavior

Only records with a ScheduledTestDate between the two filters

Context

the user clicks a buttion "Due in 90 days" and the code applies the filter. The user should only see records within that 90 day range

Your environment

I'm not set up to run these commands

Search keywords: datagrid filter

Search keywords:

[MBilalShafi]

Please provide a minimal reproduction test case with the latest version. This would help a lot 👷.

A live example would be perfect. You can find examples and guides on how to find templates in our docs with which you can provide examples for your specific use case: Support - Bug reproduction.

Thank you! 🙇🏼

[github-actions[bot]]

The issue has been inactive for 7 days and has been automatically closed.