I'm facing an issue in in two seperate Office 365 Tenants, bot show the same behaviour.
I have created a SharePoint column (Date & Time), this column has a crawled property which has been added to a OOTB RefinableDate01 Managed Peroperty.
When displaying a Filter with Bar Graph on my SharePoint page, I'm seeing my values shown as below. In another environment i'm seeing comma''s instead of dots.
Of course I want to display these values as "Last Year", "One Year Ago" etc. Who has an idea what to do?
I have tried to follow the steps in Elio Struyf's article, but since I am working with a OOTB RefinableSting, none of these steps are exactly what I am looking for.
Something has changed in the search.clientcontrols.js script. Before the RefinableDate managed properties were mapped as DateTime (which is now changed to ECMADATE). Now with the script update, they are mapped as EcmaDateRefinersInvariant which does not contain the date range labels.
As an example, I added the same date ranges also for the EcmaDateRefinersInvariant type:
Which renders this result:
The *bug* in the code is that the SearchType for the ECMADATE type is overwritten, first when they set the EcmaDateRefinersSingle and after that by EcmaDateRefinersInvariant. So when you use a RefinableDate or auto-created managed property (one with an OWSDATE suffix), it will always return as an EcmaDateRefinersInvariant type. Which does not contain date labels.
So IMO there are two solutions, adding the labels also for the EcmaDateRefinersSingle and EcmaDateRefinersInvariant types. Or changing the order of the registration, so that EcmaDate is registered last:
As a workaround, I have added a temporary template with fixes the issue. You can find it in the GitHub repository: Filter_SliderBarGraph_Date_O365.html
Accepted Solutions
Something has changed in the search.clientcontrols.js script. Before the RefinableDate managed properties were mapped as DateTime (which is now changed to ECMADATE). Now with the script update, they are mapped as EcmaDateRefinersInvariant which does not contain the date range labels.
As an example, I added the same date ranges also for the EcmaDateRefinersInvariant type:
Which renders this result:
The *bug* in the code is that the SearchType for the ECMADATE type is overwritten, first when they set the EcmaDateRefinersSingle and after that by EcmaDateRefinersInvariant. So when you use a RefinableDate or auto-created managed property (one with an OWSDATE suffix), it will always return as an EcmaDateRefinersInvariant type. Which does not contain date labels.
So IMO there are two solutions, adding the labels also for the EcmaDateRefinersSingle and EcmaDateRefinersInvariant types. Or changing the order of the registration, so that EcmaDate is registered last:
As a workaround, I have added a temporary template with fixes the issue. You can find it in the GitHub repository: Filter_SliderBarGraph_Date_O365.html