Is there a way to determine if a timestamp falls inside of a HOP?

Version 1

    Details

    Is there a way to determine if a timestamp falls inside of a HOP?


    Resolution

    HOPCalcDuration will return 0 if the time falls outside of the HOP, otherwise it returns the difference, in seconds, between the two times. You can evaluate a second in time to determine if the timestamp is inside or outside of the defined HOP.  'CurrentDateTime()' can be changed to any field that you wish to evaluate   To get just the value, you can use the formula: $(HOPCalcDuration("9 to 5", CurrentDateTime(), DateAdd("second",  1,  CurrentDateTime())))  Used in an if statement: $(if  HOPCalcDuration("9 to 5", CurrentDateTime(), DateAdd("second",  1,  CurrentDateTime())) >     0   then "Inside HOP"   else "Outside HOP")