Level 2

Solved

Customers who turn 18

7 replies
439 views
Translate

Hi, I need to identify customers who turn 18 today from the birth date with an fx. How can I do it?

Journey Optimizer

SatheeskannaKAccepted solution

Level 1

@pietroam1 Unfortunately, there isn't a function available to determine the age; instead, you'll need to utilize an expression similar to what Mohan mentioned. Another option would be to use a computed attribute.

Thanks, Sathees

Mayank_Gandhi

Employee

@pietroam1 Adobe Journey Optimizer provides Date functions, which you can use to manipulate and compare dates in your expressions, such as addYears, formatDate, and logical comparison operators.
here is what you can try:

if your birth date field is profile.person.birthDate, the expression in the audience rule or decision block would look like:

{{formatDate addYears profile.person.birthDate 18 "yyyy-MM-dd"}} == {{formatDate now "yyyy-MM-dd"}}

This logic checks if today's date (formatted as yyyy-MM-dd) matches the birth date plus 18 years (also formatted as yyyy-MM-dd). You may want to adapt the field name based on your profile schema.

Translate

PietroAm1Author

Level 2

Thnaks, just tried with expression below, swapping my schema's field

{{formatDate addYears #{ExperiencePlatform.ProfileFieldGroup.profile._cagroupit.anagraficaCliente.DATA_NASCITA} 18 "YYYY-MM-DD"}} == {{formatDate now "yyyy-MM-dd"}}

it returns error

The expression is invalid : Unexpected character '{' . Please, check that it is a valid token and that you are using it at the right place.

Translate

Mayank_Gandhi

Employee

@pietroam1 try

let dob          = #{ExperiencePlatform.ProfileFieldGroup.profile._cagroupit.anagraficaCliente.DATA_NASCITA};
let eighteenth   = date(getYear(dob)+18 ,   /* year  */
                        getMonth(dob)  ,   /* month */
                        getDayOfMonth(dob) /* day   */);

/* Compare to today */
(eighteenth == toDateOnly(now()))

Translate

Mohan_Dugganab

Employee

Kindly take a look at the following links

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/content-management/personalization/functions/dates#age

https://experienceleaguecommunities.adobe.com/t5/journey-optimizer-questions/getting-age-field/m-p/675449

Translate

SatheeskannaK

Level 1

@pietroam1 Use the computed attributes to calculate the age and use that field in the audience definition.

https://experienceleague.adobe.com/en/docs/experience-platform/profile/computed-attributes/overview

Translate

Thanks, Sathees

PietroAm1Author

Level 2

Pretty strange but we do not have this (and other functions) in AJO, that's why I've asked. I attach screenshot

Translate

SatheeskannaKAccepted solution

Level 1

@pietroam1 Unfortunately, there isn't a function available to determine the age; instead, you'll need to utilize an expression similar to what Mohan mentioned. Another option would be to use a computed attribute.

Translate

Thanks, Sathees

Sign up

Login with SSO

Login to the community

Login with SSO