Loading Custom DateTime Column in Refinement Panel WebPart – SharePoint 2013


I have a custom date time managed property column and I enabled that in the SharePoint 2013 Refinement Panel WebPart. When I configure this column in the WebPart, I selected slide bar graph option to show my custom date time column something similar like SharePoint Modified column.

But in the refinement panel my custom managed property column showed the graph with different date time format


How to get the same look and feel with the proper date time format for my custom managed properly column?


To check the field type Microsoft is using a regular expression internally. To bypass this expression and to render a custom date time managed property column in refiner properly, you should give the property name with the below format:


Here the PropertyName is case sensitive and should end with two digits.

For example:


After doing this do a full crawl and add this column in your refinement panel. Now you will get the correct format.


About Joseph Velliah
As a SharePoint Evangelist my professional interests tend to be technical and SharePoint focused. I run a blog at "SP RIDER" where you can expect to read HOW TOs and scenarios that I run into during my day to day job. I hope my posts will give back a little to the community that is helped me.

Comments are closed.

%d bloggers like this: