Reminder Email Logic in Adobe AJO

[KaruppaiahRa]

We are creating the Reminder Email using Dynamic Event Data. We've established an Events Journey and need to send a reminder within 24 hours.

Scenario [Streaming Data]: I have to validate Appointment Booked Date[e.g Date :2024-08-20T007:35:00+00:00] and send the reminder 24 hours before the Appointment booking Date [2024-08-19T007:35:00+00:00]. 

Custom Wait: setHours(toDateTimeOnly(@event{Appointment.dateTime}),-24)? I have used this Logic in Custom wait & It's not working.

In Condition: InNextHours(the dateTime of appointment,24) [This is working if the journey in between 0- to 24 hours ]

Note: Audience Logic is not helping to populate Dynamic Events Variable in the Reminder Email.
Is there any other logic for Reminder Email Setup in Adobe AJO?  Appreciate your help. Thanks in advance.

[SatheeskannaK]

@KaruppaiahRa Take a look at this thread on how you achieve this using a condition activity.

[KaruppaiahRa]

Thank you for your reply! The condition will respond immediately based on the current date, without waiting for the appointment date to calculate.
Logic from Journey Event: 15+ Dynamic Variable to populate from Events to sent Reminder. 
Scenario #1 : If appointment is 1 days before : It will match & execute
toDateTimeOnly(toString(nowWithDelta(1,"days")))==toDateTimeOnly(toString(Appointment Date))
Scenario #2 : If appointment is after 2 0r 3 or 5 or 6 or N day : It will fail & It will stop the Journey. 
 
What we have to achieve > We have to wait for Journey until  24 or 1 hours before appointment date & execute the Journey 
Expected >>> toDateTimeOnly(toString(Appointment Date)). - 24 hours or 1 Hours [looking for the logic for that]
Ex 24 hr: 08:08:2024 : 11: 30 AM - Reduce 24 Hours > 08:07:2024 : 11: 30 AM (Send Reminder for this time)
Ex 1 hr: 08:08:2024 : 11: 30 AM - Reduce 1 Hour > 08:08:2024 : 10: 30 AM (Send Reminder for this time)
---------------------------
Tried > >>>This is will change the hours to 1 always [If Hours 3 or N to 1 hour always ]>>> setHours(toDateTimeOnly(Appointment Date),1)
Tried > >>>This is will change the days to 5 always [If days 20  or N  to 5 days  ]>>> setDays(toDateTimeOnly(Appointment Date}),5)