Dynamic date condition in AJO

Question

I have a requirement in the journey that I creating. The requirement is to check on a date attribute to see if it is "y" days from current date i.e., let's say that "end_date" is 'xx-xx-xxxx xx:xx:xx' and it is equal to y days from today's date, then continue with the journey, otherwise end right there. When I pick the date field attribute and try to check if it is current_date + y days, I don't get the current_date option. It looks like the check will happen "y" days after when I create the journey. How do I implement the same in AJO?

sirisha_ganti · Accepted Answer

Hi Sathees,

I could not respond immediately. The above solution is partially correct. The right function for my use case is nowWithDelta.

toDateOnly(toString(nowWithDelta(90,'days')))=toDateOnly("2023-10-06T00:00:00")

Your note helped me find the working solution quicker.

Thank you,

Sirisha

SatheeskannaK · Answer

@sirisha_ganti, Try this expression in the journey condition considering the end date is 4 days from today.toDateOnly(toString(inNextDays(now(),4)))==toDateOnly("2023-10-06T00:00:00")

Sign up

Login with SSO

Login to the community

Login with SSO