Level 4

Solved

Date Time functions, add days?

17 replies
6730 views
Translate All

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?lang=en#set-days but couldn't find a way to achieve this.

Thank you!

Journey Optimizer

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

Zahid_14Accepted solution

Level 2

I have found a solution for calculated dates:
{% let d2 = currentTimeInMillis() + 14*86400000 %}
{% let ourDate = toDateTimeOnly(d2) %}
{%= formatDate(ourDate, "dd/MM/yyyy") %}

Kishore_Reddy

Community Advisor

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

Translate

kchaitanya

Level 3

Hi @mdonke , 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/recommendations-faq.html?lang=en#:~:text=Jan%2013%2C%202021-,Configure%20the%20profile%20script%3A,-Configure%20the%20inclusion

Translate

M

mdonkeAuthor

Level 4

Thank you @kchaitanya

I'm aware this works in target. But the question is about a Journey Optimizer

https://experienceleague.adobe.com/docs/journey-optimizer/using/personalization/build-expressions/functions/dates.html?lang=en

Translate

IvanMi1

Adobe Employee

hey @mdonke 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?

Translate

M

mdonkeAuthor

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.

Translate

M

Mandy-Steenbergen

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?

Translate

Zahid_14

Level 2

I am also trying to do the same thing. But it does not work. Please help me if anyone knows the solution.
I tried to use it:
{% let d = today %}
{%= formatDate(setDays(d,7), "D/MM/YYYY") %}
but shows like this if today is 21st August, it will show 217-08-2023

Translate

A

Anuhya-Y

Community Advisor

@zahid_14

Setdays is not right function to use in the scenario mentioned , try with nowwithdelta function

check out https://experienceleague.adobe.com/docs/journey-optimizer/using/orchestrate-journeys/building-advanced-conditions-journeys/main-functions-journey/date/functionnowwithdelta.html?lang=en

Translate

Zahid_14Accepted solution

Level 2

I have found a solution for calculated dates:
{% let d2 = currentTimeInMillis() + 14*86400000 %}
{% let ourDate = toDateTimeOnly(d2) %}
{%= formatDate(ourDate, "dd/MM/yyyy") %}

Translate

P

PandiyarajanRa1

Level 2

How to convert the specific date attribute value into milliseconds. So that we will use that attribute instead of currentTimeInMillis() like

{% let d2 = profile.dateAttribute + 14*86400000 %}
{% let ourDate = toDateTimeOnly(d2) %}
{%= formatDate(ourDate, "dd/MM/yyyy") %}

Translate

_abhishek_

Level 3

Did you get any solution for this to calculate "profile.mydate + 100 days"?

Regards,

Abhishek

Translate

E

edwint123

Adobe Employee

I was able to add thirty days to the date+time field from the AEP dataset by first converting the attribute's year, month, and day to the milliseconds and then subtracting the milliseconds elapsed from the epoch time from each. Then add them all up and then also add the 30 days converted to milliseconds at the very end, the last "2592000000" value.

{% let someDate = "insert the profile date attribute here" %}
someDate_from_ds: {%= someDate %} <br/>
{% let someDate_inMillis = (someDate.getYear() * 31556952000 - 62167195440000) + (someDate.getDayOfMonth() * 86400000 - 86400000) + (someDate.getMonth() * 2629746000 - 2629746000) + (2592000000) %} 
someDate_inMillis: {%= someDate_inMillis %}<br/> 
{% let someDate_inMillis_formatted = toDateTimeOnly(someDate_inMillis) %}
someDate_formatted_final_plus30_days: {%= formatDate(someDate_inMillis_formatted, "MM/dd/YYYY") %}

Translate

Sign up

Login with SSO

Login to the community

Login with SSO