Forum Discussion
SharePoint Search by Date
We have several business-critical Date columns that users need to filter by in search. Created and Modified provided by KQL are not enough.
We’re limited to a tiny pool of RefinableDate properties, and there’s no UI to create new Date managed properties.
This forces us into app-side filtering instead of leveraging the search index. Is there any workaround for this? Does Microsoft have any plans to modernize managed property creation for dates? It's completely unacceptable to have only 12 Refinable Dates for the entire tenant!
1 Reply
You can still have multiple date columns from across your tenant set as managed properties and feeding into a single refinable date property - so Date A from List A and Date A from List B can be mapped to a single refinable date for search purposes. It does mean you need to plan this carefully but only becomes an issue if you have more than 12 searchable date columns on a single List.
