Skip to main content
LaxaDe
New Member
May 23, 2024 9:48 AM UTC
Solved

Getting Age field

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

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Mohan_Dugganab
Mohan_DugganabAccepted solution
Adobe Employee
May 23, 2024 11:37 AM UTC

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

 

 

View in thread

3 replies

Mohan_Dugganab
Adobe Employee
Mohan_DugganabAdobe EmployeeAccepted solution
Adobe Employee
May 23, 2024 11:37 AM UTC

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
    LaxaDeAuthor
    New Member
    May 24, 2024 6:30 AM UTC

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

    Translate
    Mohan_Dugganab
    Adobe Employee
    Mohan_DugganabAdobe Employee
    Adobe Employee
    May 24, 2024 7:36 AM UTC

    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
      Terms & ConditionsAccessibility statement

      Loading footer...