> Portal Navigation:
> 
> - Append `.md` to any URL under `https://dev.wix.com/docs/` to get its markdown version.
> - Pages are either content pages (article or reference text) or menu pages (a list of links to child pages).
> - To get a menu page, truncate any URL to a parent path and append `.md` (e.g. `https://dev.wix.com/docs/sdk.md`, `https://dev.wix.com/docs/sdk/core-modules.md`).
> - Top-level index of all portals: https://dev.wix.com/docs/llms.txt
> - Full concatenated docs: https://dev.wix.com/docs/llms-full.txt

# Method name: between(propertyName: string, rangeStart: any, rangeEnd: any)

# Method package: wixData

# Method menu location: wixData --> WixDataQuery --> between

# Method Link: https://dev.wix.com/docs/velo/apis/wix-data/wix-data-query/between.md

# Method Description:

Refines a query or filter to match items whose specified property value is within a specified range.

The `between()` function refines a `WixDataQuery` or `WixDataFilter` to only
 match items where the value of the specified property is greater than or equal
 to `rangeStart` and less than `rangeEnd`.

 It only matches values of the same type. For example, a number value stored
 as a String type does not match the same number stored as a Number type.

 If a property contains a number as a String, that value will be compared
 alphabetically and not numerically. Items that do not have a value for the
 specified property are ranked lowest.

 The following types of properties can be compared:

 + Number: Compares numerically.
 + Date: Compares JavaScript Date objects.
 + String: Compares lexicographically, so
   + `"A"` and `"M"` are between `"A"` and `"Z"`, but `"a"`, `"m"`, `"z"` and `"Z"` are not.
   + `"A"`, `"M"`, `"Z"`, and `"a"` are between `"A"` and `"z"`, but `"z"` is not.



# Method Code Examples:

*** Note: do not assume any prop names or enum values other than the ones in the example.

## Add a between filter to a query

```javascript
let newQuery = query.between("age", 25, 65);
```

## Create a query, add a between filter, and run it

```javascript
import wixData from 'wix-data';

// ...

wixData.query("myCollection")
  .between("age", 25, 65)
  .find()
  .then((results) => {
    if(results.items.length > 0) {
      let items = results.items;
      let firstItem = items[0];
      let totalCount = results.totalCount;
      let pageSize = results.pageSize;
      let currentPage = results.currentPage;
      let totalPages = results.totalPages;
      let hasNext = results.hasNext();
      let hasPrev = results.hasPrev();
      let length = results.length;
      let query = results.query;
    } else {
      // handle case where no matching items found
    }
  })
  .catch((error) => {
    let errorMsg = error.message;
    let code = error.code;
  });
```

## Create a query, add a between filter and other filters, and run it

```javascript
import wixData from 'wix-data';

// ...

wixData.query("myCollection")
  .between("age", 25, 65)
  .eq("status", "active")
  .ascending("last_name", "first_name")
  .limit(10)
  .find()
  .then((results) => {
    if(results.items.length > 0) {
      let items = results.items;
      let firstItem = items[0];
      let totalCount = results.totalCount;
      let pageSize = results.pageSize;
      let currentPage = results.currentPage;
      let totalPages = results.totalPages;
      let hasNext = results.hasNext();
      let hasPrev = results.hasPrev();
      let length = results.length;
      let query = results.query;
    } else {
      // handle case where no matching items found
    }
  })
  .catch((error) => {
    let errorMsg = error.message;
    let code = error.code;
  });
```

---