Date in Advanced Expressions | Community
Skip to main content
I
IrisCo3
Level 2
February 27, 2025
Solved

Date in Advanced Expressions

  • February 27, 2025
  • 1 reply
  • 888 views

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 🙂

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

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

 

1 reply

SatheeskannaK
Community Advisor
SatheeskannaKCommunity Advisor
Community Advisor
February 27, 2025

@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

Thanks, Sathees
    I
    IrisCo3Author
    Level 2
    February 27, 2025

    Hello Satheeskanna. I couldn't use the expression you gave me. 

     

    I tried like this:

    (in(#{ExperiencePlatform.ProfileFieldGroup.timeSeriesEvents._xxxx.vacationPacakageDetails.fullDueDate} getListItem(listDateOnly, integer) to toDateOnly(toString(nowWithDelta(14,days)))==toDateOnly(toString(now())" ) )

     

     

    Can you help me? I'm new to this expressions.

     

    Thank you for your help 🙂

    SatheeskannaK
    Community Advisor
    SatheeskannaKCommunity Advisor
    Community Advisor
    February 27, 2025

    @irisco3 Try along these lines to get the records that have a due date in the next 14days from today.

     

    toDateOnly(toString(#{ExperiencePlatform.ProfileFieldGroup.timeSeriesEvents.first()._xxxx.vacationPacakageDetails.fullDueDate}))==toDateOnly(toString(nowWithDelta(14,"days")))

     

    Also, make sure the schema is profile enabled to use the "fullDueDate" part of the condition.

    Have a look at this documentation page on how to use these collection management functions.

    Thanks, Sathees
    Terms & ConditionsAccessibility statement

    Loading footer...