We have a Sharepoint 2010 farm across 4 servers and added "modfied" as a Key Filter for metadata navigation. When I select to filter on a specific day I enter a date the filtered results are out by one day, I actually have to enter the next day in the filter to find the correct items I want. E.g. to filter items modifed on 20/07/2010 I need to enter 21/07/2010 to get the results I want.
For each item the "Modified" column is showing the correct timestamp for the date/time the file was modified, so why isn't it returing the correct timestamp when I try to use the Key Filter? However 2 observations.
If there is more than a page of results, scrolling forward a page then back a page delivers the correct results.
If you remove the column from key filters then open the menu for the Modified Column Heading you can filter correctly on the dates.
All Servers and Sites or set the same regional Settings.