Date in Advanced Expressions | Adobe Higher Education
Skip to main content
I
IrisCo3
Level 2
February 27, 2025
Respondido

Date in Advanced Expressions

  • February 27, 2025
  • 1 resposta
  • 888 Visualizações

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 🙂

Este tópico foi fechado para respostas.
Melhor resposta por 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 Resposta

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
    IrisCo3Autor
    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 🙂

    Mohan_Dugganab
    Adobe Employee
    Mohan_DugganabAdobe EmployeeResposta
    Adobe Employee
    February 28, 2025

    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

     

      Termos e condiçõesAccessibility statement

      Loading footer...