Solved
Query Month and Day from Customers Date of Birth
I was wondering if it was possible to query customers whose birthday is today using their date of birth field (date field).
Hello @ryanmoravick ,
Assuming you're referring to running this query in Query Service, there are two out-of-the-box fields under the person field group for birth date: birthDayAndMonth and birthDate.
Since you're asking about the date field, I believe you are referring to birthDate.
If your birth date data is stored in the birthDate field, you can use the following query to get customers whose birthday is today:
SQL:
SELECT *
FROM table_name
WHERE TO_CHAR(person.birthDate, 'MM-DD') = TO_CHAR(CURRENT_DATE, 'MM-DD');
This query formats both the birthDate and CURRENT_DATE as MM-DD (month and day) and compares them to return the customers whose birthday is today.
Kr,
Parvesh
Parvesh Parmar – Adobe Community Advisor https://www.linkedin.com/in/parvesh-parmar/