Advanced Expression to Test Current Time

[Hankins0202]

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

[SatheeskannaK]

@Hankins0202 A similar issue has been discussed on this thread. 

[Hankins0202]

I looked there while I think that could be part of the issue. I actually think the conditional statement might be incorrect

[SatheeskannaK]

I don't think that the test activity is not working for the function that you mentioned. Can you tell me what's the requirement? and How frequently the workflow is running etc,.

[Hankins0202]

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.

[SatheeskannaK · Accepted solution]

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.

[Hankins0202]

Thank you