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 28, 2025

    Hi @mohan_dugganab . You are right! It's on an event schema.

     

    Can you please explain in more details how to create this ' segment defined (with dueDate logic)?

     

    Thank you so much for your help. 

     

    Thank you too @satheeskannak 😄

    The expression didn't work, I think it's because it's an event schema, as Mohan suggested. 

     

    Thanks 🙂


    Got it. thanks for the update. 

    If you have to create Audience (segment) logic may look like this,

    Thanks, Sathees
      Terms & ConditionsAccessibility statement

      Loading footer...