query doubt

12 replies
1870 views
Translate All

Can we create a query for submission date - current date = 7 days
how can we add this quesry in AJO journey condition box

Journey Optimizer

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

Mohan_DugganabAccepted solution

Adobe Employee

@mysteriousman

If the data type of FormSubmissionDate is dateOnly, you can validate using the following expression

toDateOnly(toString(nowWithDelta(-7,"days"))) == #{ExperiencePlatform.leadinquiry.experienceevent.at(0)._abc_partner.FormSubmissionDate}

SatheeskannaK

Adobe Champion, Community Advisor, UG Leader

@mysteriousman, Take a look at this post to construct an expression based on your needs,

https://experienceleaguecommunities.adobe.com/t5/journey-optimizer-questions/dynamic-date-condition-in-ajo/m-p/630212#M952

Translate

Thanks, Sathees

M

MYSTERIOUSMANAuthor

Level 4

@satheeskannak but submission date is not static it will be dynamic

Translate

SatheeskannaK

Adobe Champion, Community Advisor, UG Leader

@mysteriousman , Check this function if that works.

toDateOnly(toString(inNextDays(submissiondate,7)))==toDateOnly(toString(now()))

Translate

Thanks, Sathees

Sukrity_Wadhwa

Level 4

Hi @mysteriousman,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!

Translate

Sukrity Wadhwa