The current expression is ending the workflow at 7pm but we need it to continue to run until 10:50.
This is the function we are using in a test activity. What is weird is in one workflow this same formula runs until after 11 while in another it ends at 7pm.
Iif((Hour(GetDate()) > 6 AND Hour(GetDate()) <23), 1, Iif(((Hour(GetDate()) == 6 AND Minute(GetDate()) >= 30) OR (Hour(GetDate()) == 22 AND Minute(GetDate()) <= 50)), 1, 0))
The requirement is to test the current time, if the current time is between 6:30 am and 10:50pm we want to run the rest of the workflow. If that time is outside of those hours in the Easter time zone than we want the workflow to end.
Currently it works right up until 7PM. Than it is saying its outside of time condition.
I would suggest using a segmentation activity instead of a test activity to achieve the same. In the Query activity, add additional data to get the hour and minute and use that within the segmentation activity.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.