Forum Discussion
RefinableDate managed property for a calculated column is empty
I have this calculated column named "PUETADateTime" which sum up the value for other calculated columns as follow:-
now inside Search service >> I edit a Refinable Date and linked to the related managed property as follow:-
but when i am viewing this refinable inside my search web part i will get empty values,
although this calculated column have values inside sharepoint lists.. and i submit a re-index for the site around 30 hours.
Any advice?
Regards
Hi johnjohn-Peter, I've tested this in my environment, and it seems there is an issue with the RefinableDate managed property. I assigned the same crawled property from a calculated date column to two different types of refinable properties. As you can see in the screenshot, the value is only available in the String type.
I also assigned the same crawled property to different date types, but unfortunately, I didn’t get any results either
michalkornetthanks for the test which is compatible with my issue... So seems refinabledate will not work with calculated columns and hence we can not rely on calculated columns to do a filter and sort inside search web parts!!
