date function question in AJO advanced expression editor | Community
Skip to main content
C
chrisyan
Level 4
January 19, 2025
Solved

date function question in AJO advanced expression editor

  • January 19, 2025
  • 1 reply
  • 903 views

Hi There,

 

which date function below can help me use 

#{ExperiencePlatform.fieldgroup1.profile._deloittellpcanada.abnMemberDetails.tsExpect_date}  -7 days < now() that's the query I am looking for but idk which date function is feasible:

 

Best answer by vraghav

@chrisyan you can use this formula inNextDays, assuming #{ExperiencePlatform.fieldgroup1.profile._deloittellpcanada.abnMemberDetails.tsExpect_date} is of type datetime otherwise wrap it under toDateTime() function as I've done below.

 

 

 

inAudience("Your audience name") and inNextDays(toDateTime(#{ExperiencePlatform.fieldgroup1.profile._deloittellpcanada.abnMemberDetails.tsExpect_date}), 7)

 

 

 

1 reply

vraghav
Adobe Employee
vraghavAdobe EmployeeAccepted solution
Adobe Employee
January 20, 2025

@chrisyan you can use this formula inNextDays, assuming #{ExperiencePlatform.fieldgroup1.profile._deloittellpcanada.abnMemberDetails.tsExpect_date} is of type datetime otherwise wrap it under toDateTime() function as I've done below.

 

 

 

inAudience("Your audience name") and inNextDays(toDateTime(#{ExperiencePlatform.fieldgroup1.profile._deloittellpcanada.abnMemberDetails.tsExpect_date}), 7)

 

 

 

    C
    chrisyanAuthor
    Level 4
    January 20, 2025

    Thank you.

     

    can you help compose an expression to compare with now() current date and I wanted to calculate a clear date value by tsExpect_date field ex: format '2025-03-08T00:00:00.000Z' that's added +7days that will be used in the Advance query Editor within journey conditional activity to check every profile if their touchpoint date is on or before today's date.

     

    Terms & ConditionsAccessibility statement

    Loading footer...