query doubt

[MYSTERIOUSMAN]

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

[SatheeskannaK]

@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-...

[MYSTERIOUSMAN]

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

[SatheeskannaK]

@MYSTERIOUSMAN , Check this function if that works.

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

[MYSTERIOUSMAN]

Hi @SatheeskannaK 

toDateOnly(toString(inNextDays(#{ExperiencePlatform.leadinquiry.experienceevent.at(0)._abc_partner.FormSubmissionDate},7)))==toDateOnly(toString(now()))

if is throwing an error can you have a look what to do 
this is the attribute  which we are taking it form AEP
#{ExperiencePlatform.leadinquiry.experienceevent.at(0)._abc_partner.FormSubmissionDate}

is there is any error plz lets us know

[SatheeskannaK]

@MYSTERIOUSMAN It should work as long as FormSubmissionDate is datetime field. 

toDateOnly(toString(inNextDays(#{ExperiencePlatform.testFieldGroup.profile.timeSeriesEvents.at(0).extSourceSystemAudit.lastActivityDate},7)))==toDateOnly(toString(now()))

If not you will have to apply the conversion.

[Sukrity_Wadhwa]

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!

[MYSTERIOUSMAN]

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)

[dugganab · Accepted solution]

@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}

[MYSTERIOUSMAN]

Not working 

[Mohan1990]

What is the error ?

[MYSTERIOUSMAN]

condtion is not working 

[dugganab]

It does work.

For the sake of validation, I have hardcoded the submission date to 2023-12-09 and see the profile pass through.

toDateOnly(toString(nowWithDelta(-7,"days"))) ==toDateOnly('2023-12-09')

Reference-