Retrieve contacts whose birthday is today RRS feed

  • Question

  • Hi,

    Suppose i want to retrieve contacts whose birthday is today, is it possible to compare only the day and month in the condition of the query, i have tried with fetchXml, LINQ and Query expression and feel its not possible. Any work around for this apart from creating a custom field.

    Any help on this is appreciated.

    Kruthi Hegde

    Friday, November 11, 2016 11:07 AM

All replies

  • Hello,

    I'm afraid the only good way is to add 2 additional fields to your contact entity that will store day of month and month of birth. Additionally you will have to develop code that will populate those fields during create/update of contact. After that you will have possibility to use those fields in queries.

    Dynamics CRM MVP
    Read My blog
    Subscribe for one of my courses

    Sunday, November 13, 2016 7:05 AM