# Introduction to the Between Check

Source: https://userguide.qualytics.io/data-quality-checks/between/introduction/

*Requires the Data Quality (DQ) module.*

The Between check asserts that every value in a numeric field falls inside a minimum and maximum boundary, with each side independently inclusive or exclusive. Use it to enforce a valid range such as an age, a percentage, a score, or a monetary amount.

This section is the complete guide to the check. The Deep Dive covers the definition, properties, and full evaluation semantics, explains how anomalies are reported, walks through production examples, and collects best practices; the How-tos are step-by-step tutorials for creating, editing, and deleting a check; the API page documents the payload for programmatic use; and the FAQ answers the most frequent questions.

## Next Steps

- **How It Works**

  The complete reference: definition, field scope, properties, boundary inclusivity, NULL handling, filter behavior, and coverage.

  [How It Works](https://userguide.qualytics.io/data-quality-checks/between/deep-dive/how-it-works/)
- **Anomaly Reporting**

  The anomaly messages the check produces, what the numbers mean, Source Records highlighting, and Custom Anomaly Description.

  [Anomaly Reporting](https://userguide.qualytics.io/data-quality-checks/between/deep-dive/anomaly-reporting/)
- **Examples**

  Three production scenarios with sample data, anomaly messages, and the SQL equivalent of what the check evaluates.

  [Examples](https://userguide.qualytics.io/data-quality-checks/between/deep-dive/examples/)
- **Best Practices**

  Guidelines for choosing boundaries, setting inclusivity, pairing rules, and keeping the signal clean.

  [Best Practices](https://userguide.qualytics.io/data-quality-checks/between/deep-dive/best-practices/)
- **Permissions**

  The team permission each action needs: view, create, edit, archive, restore, and delete.

  [Permissions](https://userguide.qualytics.io/data-quality-checks/between/deep-dive/permissions/)
- **Create a Check**

  Step-by-step tutorial for creating a Between check with a minimum and a maximum boundary.

  [Create a Check](https://userguide.qualytics.io/data-quality-checks/between/how-tos/create-a-check/)
- **Edit a Check**

  Step-by-step tutorial for changing the boundaries, inclusivity, filter, coverage, or organizational properties.

  [Edit a Check](https://userguide.qualytics.io/data-quality-checks/between/how-tos/edit-a-check/)
- **Delete a Check**

  Step-by-step tutorial for archiving a check and deleting it permanently.

  [Delete a Check](https://userguide.qualytics.io/data-quality-checks/between/how-tos/delete-a-check/)
- **Troubleshooting**

  Common problems with boundary inclusivity, NULLs, type mismatches, and anomaly reporting, and how to resolve them.

  [Troubleshooting](https://userguide.qualytics.io/data-quality-checks/between/troubleshooting/)
- **API**

  Payload shape and field notes for creating a Between check programmatically.

  [API](https://userguide.qualytics.io/data-quality-checks/between/api/)
- **FAQ**

  Short answers to questions about boundaries, inclusivity, NULLs, and anomaly reporting.

  [FAQ](https://userguide.qualytics.io/data-quality-checks/between/faq/)

*Last updated: October 19, 2026.*
