Dynamic date condition in AJO

[sirisha_ganti]

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?

[SatheeskannaK]

@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")

[sirisha_ganti · Accepted solution]

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]

I'm glad that it was helpful for you. Thanks for posting the solution that worked for your use case.

[sirisha_ganti]

Is there a way to calculate the difference from a field whose value is date, for example -

@{Myevent._xyz.subscription.expiry_date} - 90 'days'? 

I want to use the above in a wait condition.

Thank you,

Sirisha

[SatheeskannaK]

@sirisha_ganti You can try setDays function. Remember wait activity will accept dateTimeOnly format.

https://experienceleague.adobe.com/docs/journey-optimizer/using/orchestrate-journeys/building-advanc...

setDays(toDateTimeOnly(@{Myevent._xyz.subscription.expiry_date}),-90)

[sirisha_ganti]

Thank you for your reply. I will try it and get back.

Thank you,

Sirisha

[AvinashNa1]

Hi @SatheeskannaK 

We have similar requirement but the setDays is throwing a run time error when it have a negative number of days.
Set Days is trying to set to that particular day of the month (if provided positive)

Is there any other function that can be used to achieve this?

@sirisha_ganti 

Thanks

[IswarenSiman]

Hello @sirisha_ganti and @SatheeskannaK ,

Is it possible to change the '90 days' to a calculated value?

e.g. toDateOnly(toString(nowWithDelta(round(122/3),'days')))

I'm also not able to use a dynamic value here:

e.g. toDateOnly(toString(nowWithDelta(#{ExperiencePlatform.DateFields.profile._repo.createDate},'days')))

Thanks

[Sukrity_Wadhwa]

Hi @sirisha_ganti,

Was the given solution by @SatheeskannaK helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!

[sirisha_ganti]

Hi Sukrity,

Thank you for the follow up. That was helpful.

regards,

Sirisha

[Sukrity_Wadhwa]

Thanks for the update @sirisha_ganti!