Last updated: July 22, 2025

List of column level datetime data quality checks

This is a list of datetime column data quality checks supported by DQOps and a brief description of what data quality issued they detect.

column-level datetime checks

Validates that the data in a date or time column is in the expected format and within predefined ranges.

date values in future percent

Detects dates in the future in date, datetime and timestamp columns. Measures a percentage of dates in the future. Raises a data quality issue when too many future dates are found.

Data quality check name	Friendly name	Check type	Description	Standard
profile_date_values_in_future_percent	Maximum percentage of rows containing dates in future	profiling	Detects dates in the future in date, datetime and timestamp columns. Measures a percentage of dates in the future. Raises a data quality issue when too many future dates are found.
daily_date_values_in_future_percent	Maximum percentage of rows containing dates in future	monitoring	Detects dates in the future in date, datetime and timestamp columns. Measures a percentage of dates in the future. Raises a data quality issue when too many future dates are found. Stores the most recent captured value for each day when the data quality check was evaluated.
monthly_date_values_in_future_percent	Maximum percentage of rows containing dates in future	monitoring	Detects dates in the future in date, datetime and timestamp columns. Measures a percentage of dates in the future. Raises a data quality issue when too many future dates are found. Stores the most recent check result for each month when the data quality check was evaluated.
daily_partition_date_values_in_future_percent	Maximum percentage of rows containing dates in future	partitioned	Detects dates in the future in date, datetime and timestamp columns. Measures a percentage of dates in the future. Raises a data quality issue when too many future dates are found. Stores a separate data quality check result for each daily partition.
monthly_partition_date_values_in_future_percent	Maximum percentage of rows containing dates in future	partitioned	Detects dates in the future in date, datetime and timestamp columns. Measures a percentage of dates in the future. Raises a data quality issue when too many future dates are found. Stores a separate data quality check result for each monthly partition.

date in range percent

Verifies that the dates in date, datetime, or timestamp columns are within a reasonable range of dates. The default configuration detects fake dates such as 1900-01-01 and 2099-12-31. Measures the percentage of valid dates and raises a data quality issue when too many dates are found.

Data quality check name	Friendly name	Check type	Description	Standard
profile_date_in_range_percent	Minimum percentage of rows containing dates within an expected range	profiling	Verifies that the dates in date, datetime, or timestamp columns are within a reasonable range of dates. The default configuration detects fake dates such as 1900-01-01 and 2099-12-31. Measures the percentage of valid dates and raises a data quality issue when too many dates are found.
daily_date_in_range_percent	Minimum percentage of rows containing dates within an expected range	monitoring	Verifies that the dates in date, datetime, or timestamp columns are within a reasonable range of dates. The default configuration detects fake dates such as 1900-01-01 and 2099-12-31. Measures the percentage of valid dates and raises a data quality issue when too many dates are found. Stores the most recent captured value for each day when the data quality check was evaluated.
monthly_date_in_range_percent	Minimum percentage of rows containing dates within an expected range	monitoring	Verifies that the dates in date, datetime, or timestamp columns are within a reasonable range of dates. The default configuration detects fake dates such as 1900-01-01 and 2099-12-31. Measures the percentage of valid dates and raises a data quality issue when too many dates are found. Stores the most recent check result for each month when the data quality check was evaluated.
daily_partition_date_in_range_percent	Minimum percentage of rows containing dates within an expected range	partitioned	Verifies that the dates in date, datetime, or timestamp columns are within a reasonable range of dates. The default configuration detects fake dates such as 1900-01-01 and 2099-12-31. Measures the percentage of valid dates and raises a data quality issue when too many dates are found. Stores a separate data quality check result for each daily partition.
monthly_partition_date_in_range_percent	Minimum percentage of rows containing dates within an expected range	partitioned	Verifies that the dates in date, datetime, or timestamp columns are within a reasonable range of dates. The default configuration detects fake dates such as 1900-01-01 and 2099-12-31. Measures the percentage of valid dates and raises a data quality issue when too many dates are found. Stores a separate data quality check result for each monthly partition.

text match date format percent

Verifies that the values in text columns match one of the predefined date formats, such as an ISO 8601 date. Measures the percentage of valid date strings and raises a data quality issue when too many invalid date strings are found.

Data quality check name	Friendly name	Check type	Description	Standard
profile_text_match_date_format_percent	Minimum percentage of rows containing text values that match a date format	profiling	Verifies that the values in text columns match one of the predefined date formats, such as an ISO 8601 date. Measures the percentage of valid date strings and raises a data quality issue when too many invalid date strings are found.
daily_text_match_date_format_percent	Minimum percentage of rows containing text values that match a date format	monitoring	Verifies that the values in text columns match one of the predefined date formats, such as an ISO 8601 date. Measures the percentage of valid date strings and raises a data quality issue when too many invalid date strings are found. Creates a separate data quality check (and an alert) for each daily monitoring.
monthly_text_match_date_format_percent	Minimum percentage of rows containing text values that match a date format	monitoring	Verifies that the values in text columns match one of the predefined date formats, such as an ISO 8601 date. Measures the percentage of valid date strings and raises a data quality issue when too many invalid date strings are found. Creates a separate data quality check (and an alert) for each monthly monitoring.
daily_partition_text_match_date_format_percent	Minimum percentage of rows containing text values that match a date format	partitioned	Verifies that the values in text columns match one of the predefined date formats, such as an ISO 8601 date. Measures the percentage of valid date strings and raises a data quality issue when too many invalid date strings are found. Stores a separate data quality check result for each daily partition.
monthly_partition_text_match_date_format_percent	Minimum percentage of rows containing text values that match a date format	partitioned	Verifies that the values in text columns match one of the predefined date formats, such as an ISO 8601 date. Measures the percentage of valid date strings and raises a data quality issue when too many invalid date strings are found. Stores a separate data quality check result for each monthly partition.