Expand my Community achievements bar.

The 2nd edition of the Journey Optimizer Community Lens newsletter is out now!

Date Time functions, add days?

Avatar

Level 4

Any tipps how I can add a given amount of days to a given datetime profile attribute?

 

E.g.

profile.mydate + 100 days

Thursday, 11 November 2021 + 100 days = Saturday, 19 February 2022

 

I checked https://experienceleague.adobe.com/docs/journey-optimizer/using/personalization/functions/dates.html... but couldn't find a way to achieve this.

 

Thank you!

6 Replies

Avatar

Community Advisor

Haven't experienced this yet. Please reach out to clientcare@adobe.com 

Avatar

Level 4

Hi @maggod , you could try a profile script similar to one show in the document here (this will have to be done in Target): 

https://experienceleague.adobe.com/docs/target/using/recommendations/recommendations-faq/recommendat... 

Avatar

Employee

hey @maggod  can you help me to understand the usecase? Is this for a condition check, or you are trying to append data? Or just format/change a string? 

Avatar

Level 4

Hi Ivan

 

I wanted to render some personalized text into AJO message content.

Example:

"Your contract will end Sept 1st 2022".

"Sept 1st 2022" should be calculated based on a profile attribute (like "contract/abc/contractStartDate") plus 2 years.

 

 

Avatar

Level 1

Hi, I'm currently trying to do the exact same thing (add 7 days to a dateTime field to get a new dateTime that is 7 days in the future). Is there already a solution or workaround for this? 

page footer