Can we create a query for submission date - current date = 7 days
how can we add this quesry in AJO journey condition box
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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}
Views
Replies
Total Likes
@MYSTERIOUSMAN, Take a look at this post to construct an expression based on your needs,
Views
Replies
Total Likes
@SatheeskannaK but submission date is not static it will be dynamic
Views
Replies
Total Likes
@MYSTERIOUSMAN , Check this function if that works.
toDateOnly(toString(inNextDays(submissiondate,7)))==toDateOnly(toString(now()))
Views
Replies
Total Likes
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
Views
Replies
Total Likes
@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.
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
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)
Views
Replies
Total Likes
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}
Views
Replies
Total Likes
Not working
Views
Replies
Total Likes
What is the error ?
Views
Replies
Total Likes
condtion is not working
Views
Replies
Total Likes
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-