Is it possible to calculate age from date of birth using Data Prep or inside a condition in a journey?

[Sindhe]

@Saurav , @Danny-Miller  There is a date of birth field in profile. The requirement is to create segments based on age. Is it possible to calculate the age from date of birth within AEP?

[Anil_Umachigi]

@Sindhe Data prep may not be right option here, assuming this profile dataset is not ingested on daily basis. Data prep runs only during data ingestion. 

One way i would think of doing this is 

1. set a ageAsOfToday field in the schema 
2. Run a query service job (scheduled every night) which updates this field for all profiles. 
3. Use this field in segment which will be evaluated everyday with accurate age info

[Sindhe]

Doesn't this require Data Distiller license?

[Anil_Umachigi]

@Sindhe Probably, depends on how your license is set up. 

[bjoern__koth]

Hi @Anil_Umachigi ,

stumbled upon this thread. Being fairly new to query service, have you come along an actual implementation on this specific query?

[birthariyamayank]

You can use data prep to calculate age but the this will not be recalculated unless you ingest the record again.
I would either, based on requirement, use Query Service or just create segments to qualify users in certain age groups

[Danny-Miller]

@Sindhe Unless I'm missing something, if you have DOB, then the Segment uses Rolling Range to calculate age.

[ChetanyaJain · Accepted solution]

@Sindhe, the computed attributes feature (in beta currently) will be super helpful in your case.

https://experienceleague.adobe.com/docs/experience-platform/profile/computed-attributes/ca-api.html#....

You can define a field "age" at the profile level, define the computation, and leave it. 

[sambhav-jain]

Hi Chetanya,

The page link you shared is not accessible now. Please share the update link.

[ChetanyaJain]

Hi @sambhav-jain, unfortunately, the page is taken offline. I believe this is a feature that is likely to be released in the future.