Date in Advanced Expressions

Question

I need to create an expression where I select only people who the payment will expire in 14 days FROM today. The expiration field is called DueDate.

The logic would be currant date + 14.

What expression should I use and how it would look like?

Thanks 🙂

Mohan_Dugganab · Accepted Answer

Looks like vacationPacakageDetails.fullDueDate is on the experience event schema ?

Accessing experience event attributes via #{ExperiencePlatform.ProfileFieldGroup.timeSeriesEvents._xxxx.vacationPacakageDetails.fullDueDate} will not work (if you are using this in a batch journey starting with a read audience). You will need to have a segment defined (with dueDate logic) which can be used in the journey

If you are using this in an event triggered journey, you will have to adapt the expression accordingly

toDateOnly(toString(<Experience_event_attribute_pointing_to_fullDueDate>))==toDateOnly(toString(nowWithDelta(14,"days")))

This is assuming fullDueDate is a not within a array or array of objects

SatheeskannaK · Answer

@irisco3 If it's in the journey condition to filter the profiles use this function.

toDateOnly(toString(nowWithDelta(14,"days")))==toDateOnly(toString(now()))

Refer this thread for more details.

If you want to display the due date in the email following this page and functions,

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/content-management/personalization/functions/dates

Sign up

Login with SSO

Login to the community

Login with SSO