The Recent Data Validation rule verifies that date or timestamp values fall within a defined recency period (e.g. past 30 days, past 6 months).
This ensures that records remain timely, relevant, and aligned with business expectations.
Example Usage:
- Check that customer orders were placed within the last 30 days
- Validate that employee certifications are updated within the last year
Configuration Fields
Rule-Specific Configuration
| Field Name | Description | Required | Data Type |
|---|
| Recency Period | The number representing how far back from today to check | Yes | Number |
| Unit | The unit for the recency period | Yes | Days, Weeks, Months, Years |
Success Criteria Configuration
| Field Name | Description | Required | Options / Format |
|---|
| Operator | Comparison operation for the result count | Yes | GreaterThan, LessThan, EqualTo, Between |
| Threshold Value | Value for comparison (for non-Between operators) | Conditional | Number |
| Threshold Min | Minimum value (for Between operator) | Conditional | Number |
| Threshold Max | Maximum value (for Between operator) | Conditional | Number |
| Threshold Type | Whether threshold represents an absolute count or percentage | No | Absolute Count / Percentage |
| Allow Nulls | Whether null values should be treated as valid | No | true / false (default: false) |
| Check For Match | Whether to validate for match or negation of the recency condition | No | true / false (default: true) |
| ID | Date | Due Date |
|---|
| 1 | 2025-02-06 | 2025-02-08 |
| 2 | 2024-10-09 | 2024-12-08 |
| 3 | 2024-11-14 | 2025-01-10 |
| 4 | 2024-09-03 | 2024-12-15 |
| 5 | 2025-01-23 | 2025-01-29 |
| 6 | 2025-01-01 | 2025-01-25 |
| 7 | 2024-01-10 | 2024-01-30 |
Sample Configurations
Example: Date Recency Validation
| Configuration Field | Value |
|---|
| Recency Period | 30 |
| Unit | Days |
| Operator | GreaterThan |
| Threshold Value | 3 |
| Threshold Type | Absolute Count |
| Allow Nulls | false |
| Check For Match | false |
Explanation:
Validates that more than 3 records have a date value older than 30 days from today.
Check For Match set to false inverts the match, counting how many records are not recent.
Sample Output
| Column Name | Rule Name | Success Count | Failure Count | Null Count | Within Threshold |
|---|
| Date | Recent Data Validation | 2 | 5 | 0 | No |
| Due Date | Recent Data Validation | 4 | 3 | 0 | Yes |
