timeBetween
Description
Checks to see if the given time is between the start and end times. The given times are expected as strings, and may include dates. Note: dates will be parsed according to the default system culture.
Syntax
timeBetween( date,date,date )
Examples
timeBetween(toDate(
"2003-9-14 12:00:00"
), toDate(
"2003-9-14 8:00:00"
),toDate(
"2003-9-14 18:00:00"
))
//returns true
timeBetween(
"2:00:00 pm"
,
"9:00:00 am"
,
"5:00:00 pm"
)
//returns true
timeBetween(toDate(
"2003-9-14 20:00:00"
), toDate(
"2003-9-14 18:00:00"
), toDate(
"2003-9-15 2:00:00"
))
//returns true