not between ... and ...Returns TRUE for values not in a given range
Works with the following datatypes:
This function works with 2.1 endpoint(s). What does this mean? »
not between is used with the $where parameter to return numeric or time stamp values excluding those between two input values. For example, to get all of the individuals who make less than $40,000 or more than $150,000 at the City of Chicago:
It can also be used on Floating Timestamps. For example, to get all of the crimes that occurred outside noon and 2PM on January 10th, 2015 in Chicago: