Filters a record set for data matching the values in an inclusive range.
between can operate on any numeric, datetime, or timespan expression.
If expr expression is datetime - another syntactic sugar syntax is provided:
- T - The tabular input whose records are to be matched.
- expr - the expression to filter.
- leftRange - expression of the left range (inclusive).
- rightRange - expression of the right range (inclusive).
Rows in T for which the predicate of (expr >= leftRange and expr <= rightRange) evaluates to
Filter numeric values
range x from 1 to 100 step 1 | where x between (50 .. 55)
StormEvents | where StartTime between (datetime(2007-07-27) .. datetime(2007-07-30)) | count
StormEvents | where StartTime between (datetime(2007-07-27) .. 3d) | count