Forum Discussion
I need help with KQL search query - I want to list people who have birthdays on the current month.
I need a KQL something similar below to list users who were born in the current month
Birthday:"this month" -ContentClass=urn:content-class:SPSPeople
The above doesn't return anything.
When I look at the crawled property I can see as above it has been mapped to RefinableDate17 .
But I can't see these properties in Azure when i try to update my birthday. Should i be abe to use a KQL query to do this and how can i get the birthday property to show in azure so i can update the birthday field?
Thanks in Advance
1 Reply
Hello Patrick Rote
not sure to understand you correct, but i try my best 🙂
Microsoft Entra ID will be synchronize the properties to User Profile Application in SharePoint, but not all properties will be synchronize. Here are a list of the properties, others, you can add with script: https://learn.microsoft.com/en-us/sharepoint/user-profile-sync?WT.mc_id=DX-MVP-5004845
When the date of birth is synchronized, here are an example for a people directory: https://microsoft-search.github.io/pnp-modern-search/scenarios/Create-a-useful-People-Search/
And here is a table with existing date parameters:
Hope you can use this informations to build your solution.
Best, Dave
