SharePoint 2010 date key filters are 1 day off

Strange thing on the SharePoint sites here.
I am working with a long list of items and I am using key filters (metadata navigation functionality).

When I search for all items with creation date on (for example, DDMMYYYY) 05/05/2010, it will show me all items with creation date 04/05/2010.
So my key filters are 1 day off ! This is of course quite strange and not really useful to my clients. After a long and extensive search we found that Microsoft put a solution in their last cumulative update.

Description of the SharePoint Server 2010 cumulative update package (MOSS server-package): April 28, 2011
Issues that this hotfix package fixes
Consider the following scenario:
o You set the time zone as Coordinated Universal Time (UTC) time in SharePoint Server 2010.
o You add a key filter that is based on the Date Time field in a document library.
o You set the key filter to the date when a document was uploaded.
o You search for the document.

In this scenario, the key filter does not function correctly. Therefore, the document does not display in the search results.

About: Marijn

Marijn Somers (MVP) has over 14 years experience in the SharePoint world, starting out with SP2007. Over the years the focus has grown to Office 365, with a focus on collaboration and document management. He is a business consultant at Balestra and Principal Content Provider for "Mijn 365 Coach" that offers dutch employee video training. His main work tracks are around user adoption, training and coaching and governance. He is also not afraid to dig deeper in the technicalities with PowerShell, adaptive cards or custom formatting in lists and libraries. You can listen to him on the biweekly "Office 365 Distilled" podcast.

%d bloggers like this: