Expand my Community achievements bar.

Nomination window for the Adobe Community Advisor Program, Class of 2025, is now open!

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

Avatar

Level 1

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)"

2 Replies

Avatar

Community Advisor and Adobe Champion

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

 

There are couple of options 

  1. 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) 
  2. Post Ingestion: Try query service to populate the value into a new field. 

 

Anil

Avatar

Level 1

Hi @Anil_Umachigi,

 

We want to send email using AJO as soon as the user qualify for the Audience.

 

Thanks