Columns Not Filtering Correctly in Grid View

Columns which have been modified (rounded to two decimal values or have changed date-time formats), will not be filtered in Grid View.

Cause

This issue relates to the difference between actual data and visual data.

Grid View filters are based upon visual data whereas the filters component uses actual data.

Solution

alternatively,