I want to send a birthday email.
So I already connect both the cloud and get the record of contact object into the sync data extension and I also created a standard data extension in marketing cloud.
Now when I am creating Automation Studio and select first activity as a query which will update my standard data extension.
Now my question how to send an email who has a birthday today only?
So can anyone suggest me a query to achieve this?
Note: I created one field in contact named "Birthday" and another field in contact is for "BirthdayCurrentYear" this is the formula field.