query doubt | Community

Level 4

Solved

query doubt

12 replies
1794 views
Translate

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

Employee

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}

Employee

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

MYSTERIOUSMANAuthor

Level 4

Hi @satheeskannak

the attribute submission date

Data Type is Date only can you helps us to form the query for that

submission date = 7 days

(Assume that 19-11-2023 i submitted form and send the mail after 7 days and submission date is day 0 mail should be sent on. 27-11-2023)

Translate

Mohan_DugganabAccepted solution

Employee

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}

Translate

Level 1

@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

MYSTERIOUSMANAuthor

Level 4

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

Translate

Level 1

@mysteriousman , Check this function if that works.

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

Translate

Thanks, Sathees