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.

 

PatrickRote_1-1693981922421.png

 

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:

https://learn.microsoft.com/en-us/sharepoint/dev/general-development/keyword-query-language-kql-synt...

 

Hope you can use this informations to build your solution.

 

Best, Dave