between ... and ...Returns TRUE for values in a given range
Works with the following datatypes:
This function works with 2.1 and 3.0 endpoint(s). What does this mean? »
between is used with the $where parameter to return numeric or time stamp values between two input values. For example, to get all of the individuals who make between $40,000 and $60,000 at the City of Chicago:
The TryIt macro has been disabled until future notice while we upgrade this site to SODA3. It can also be used on Floating Timestamps. For example, to get all of the crimes that occurred between noon and 2PM on January 10th, 2015 in Chicago:
The TryIt macro has been disabled until future notice while we upgrade this site to SODA3.