Excel Style Filtering on dateTime columns not applied properly

[RivaIvanova]

Description

When having multiple grids in the application, excel style filtering is not applied properly on DateTime column if the first grid has a Date column, and the second has a DateTime column.

As demonstrated in the below attachment, when selecting any DateTime value for which there are other entries on the same date, multiple records are displayed, but only one matches the selected DateTime (left side).

However, when the grid with the DateTime column is above the one with the Date column, the correct record is displayed. (right side)

---

The same is true when the Date column is before the DateTime column in a single grid:

• igniteui-angular version: 13.0.x, 12.3.x
• browser: all

Steps to reproduce

1. Open this StackBlitz sample.
2. Filter the Order Date column in the second grid by selecting the first value (Mar 17, 2001, 10:20:37 AM)

Result

Multiple records for Mar 17, 2001 are displayed.

Expected result

Only one record should be displayed.

[m4yorga]

Hello @RivaIvanova , @DiyanDimitrov , is there any update about this issue?

Thanks.