Skip to content

Date within range (min/max)

date_range - Column-level - Date and time

Validates that a date or datetime column's values fall within an expected range.

Parameters

Parameter Type Default Required Description
min_date str none No Optional minimum allowed date (inclusive), ISO format YYYY-MM-DD.
max_date str none No Optional maximum allowed date (inclusive), ISO format YYYY-MM-DD.
threshold_percent float 0.0 No Fail if the percentage of out-of-range values exceeds this.

YAML example

checks:
  - name: example_date_range
    check_type: date_range
    table_name: schema.table
    column_name: example_column
    parameters:
      threshold_percent: 0.0

See YAML check format for the full field reference.