I need help with KQL search query - I want to list people who have birthdays on the current month.

Iron Contributor

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