Can you help me with a query to get the current date to send a Birthday email? I am trying to using the Profile Attribute, Advanced Mode, and creating an expression (using @birthDate = GetDate()) but this is not returning any value. Can you help?
So In this case I would create, before the birthday check, a new field in Enrichemnt activity bday_currentYear and checked that date as I described previously. You can create this field by using functions e.g
Doing it your doesn't take the year into consideration.
You say birthday (i.e.DD/MM) but it's actually the date of birth (i.e. DD/MM/YYYY) so saying X date is equal to date of birth would almost always pull incorrect information (as it's very unlikely a recipient will have a date of birth in 2018!)