IsTimeBetween

Returns true when the current clock time falls inside a window. The window is half-open: it includes the start time and excludes the end time. When the end time is earlier than the start time, the window crosses midnight.

Category: Time Returns: bool

Signature

IsTimeBetween(start, end)

Both arguments are clock times written as quoted “HH:MM” text, like ‘22:00’. The validator rejects anything else.

Examples

IsTimeBetween('09:00', '17:00')   // true during business hours
IsTimeBetween('22:00', '06:00')   // true at 23:00 AND at 03:00 (crosses midnight)
!IsTimeBetween('06:00', '22:00')  // the same night window, written inside out

Notes

• Requires time to be enabled for the project (Project, then Time). With time disabled, any expression using this function fails validation.
• The half-open window composes cleanly at time-bucket edges: IsTimeBetween(‘06:00’, ‘12:00’) and IsTimeBetween(‘12:00’, ‘17:00’) never overlap and leave no gap at 12:00.
• When start and end are the same time, the window is empty and the function always returns false. There is no way to write a full-day window; a condition that should hold all day doesn’t need a time check.
• To react to a window that is about to close, pair with MinutesUntil.