Getting Age field

3 replies
1005 views
Translate

Hi,

Using Arithmetic function to calculate the age from Date of Birth field we are getting the below error.

How can we get the age calculated in AJO? attaching the screen shot of the error

Journey Optimizer

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Mohan_DugganabAccepted solution

Employee

You can use the following snippet as a reference

((((toInteger(substr(toString(now()),0,4))) - 
(toInteger(substr((#{ExperiencePlatform.ProfileFieldGroup.profile._tenant.personExtn.birthDateStr}),0,4)))) <= 40))
and
((((toInteger(substr(toString(now()),0,4))) - 
(toInteger(substr((#{ExperiencePlatform.ProfileFieldGroup.profile._tenant.personExtn.birthDateStr}),0,4)))) >= 18))

Mohan_DugganabAccepted solution

Employee

You can use the following snippet as a reference

((((toInteger(substr(toString(now()),0,4))) - 
(toInteger(substr((#{ExperiencePlatform.ProfileFieldGroup.profile._tenant.personExtn.birthDateStr}),0,4)))) <= 40))
and
((((toInteger(substr(toString(now()),0,4))) - 
(toInteger(substr((#{ExperiencePlatform.ProfileFieldGroup.profile._tenant.personExtn.birthDateStr}),0,4)))) >= 18))

Translate

L

LaxaDeAuthor

New Participant

@mohan_dugganab Thanks for the reply. can we get the age value so it can be exported externally?

Translate

Mohan_Dugganab

Employee

You can actually write the value of this expression using update profile activity into one of the existing attributes on profile (say age) and then use it for exports

Kindly take a note of the below - https://experienceleague.adobe.com/en/docs/journey-optimizer/using/orchestrate-journeys/about-journey-building/update-profiles

If you would like this to be handled as part of data load itself, you may want to explore data prep functionality https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/home

Translate

Sign up

Login with SSO

Login to the community

Login with SSO