Filtering UTCDateTime returns wrong result


I have a requirement where I need to filter records based on UTCDateTime filed. But when I provide correct date for ex : 10/06/2010, it is not filtering any records. but if I provide date as 11/06/2010 it is filtering all results having date value “10/06/2010”.


Scenario 1:

UTCDateTime Value : 10/06/2010

Grid :

Column1 Column2 Column3

No records are displayed

Scenario: 2

UTCDateTime Value : 11/06/2010

Grid :

Column1 Column2 Column3

1 10/06/2010 XYZ

2 10/06/2010 ABC

Please help me in resolving this.

How did you define the filter? Has the time zone been applied correctly?