Level 2

Solved

How to extract year from date in AJO using fx function?

2 replies
1021 views
Translate All

We want to supply Year in Custom action from the field called registration Date which is in format "YYYY-MM-DD".
Inside AJO which fx function we should use to extract year from the same.

For example, RegistrationDate ="2022-07-08" , we want to use field as StartYear having value "2022".

Please assist.

Journey Optimizer

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

SatheeskannaKAccepted solution

Adobe Champion, Community Advisor, UG Leader

Try this:

substr(toString(#{ExperiencePlatform.ProfileFieldGroup.profile.person.RegistrationDate}),0,3)

Make sure you have the appropriate path for the registration date attribute.

Thanks, Sathees

Adobe Champion, Community Advisor, UG Leader

Accepted solution

Adobe Champion, Community Advisor, UG Leader

Try this:

substr(toString(#{ExperiencePlatform.ProfileFieldGroup.profile.person.RegistrationDate}),0,3)

Make sure you have the appropriate path for the registration date attribute.

Translate

Thanks, Sathees

Adobe Employee

This should be substr(toString(#{ExperiencePlatform.ProfileFieldGroup.profile.person.RegistrationDate}),0,4)

Translate