Solved

query doubt

Forum|Forum|2 years ago
November 3, 2023
2 replies
1786 views

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.

Best answer by Mohan_Dugganab

@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

Community Advisor

@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

Thanks, Sathees

M

MYSTERIOUSMANAuthor

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

SatheeskannaK

Community Advisor

@mysteriousman , Check this function if that works.

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

Thanks, Sathees

Sukrity_Wadhwa

Community Manager

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!

Sukrity Wadhwa