How to use person.birthDayAndMonth in audience to send birthday greeting

Question

Hi Team,

What is the best way to qualify the users to an audience based on their "MM-DD" details provided by them on out-of-box field(person.birthDayAndMonth). The audience will be used to send Birthday Greetings.

I tried to use below PQL, however it throws a datatype error as its trying to compare string with Integer. And we don't have datatype cast function.

"person.birthDayAndMonth.startsWith(currentMonth(), false) and person.birthDayAndMonth.endsWith(currentDayOfMonth(), false)"

Anil_Umachigi · Answer

@abhaya999 Could you add more context? Where are you trying to send this field? AJO or Target?

There are couple of options

Before data ingestion: Try using Data prep function and convert to format desired either to same field or a new field ( create new field in schema)
Post Ingestion: Try query service to populate the value into a new field.

Anil

Sign up

Login with SSO

Login to the community

Login with SSO