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

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-syntax-reference#relevant-date-intervals-supported-by-kql?WT.mc_id=DX-MVP-5004845

Hope you can use this informations to build your solution.

Best, Dave