1.3.3.8.23 Comparison: Date Too Different (Solutions)
The Date Too Different (Solutions) comparison compares two Date values and returns true if they are significantly different based on the configuration options. The comparison uses the typographical edit distance and absolute distance of the values in its calculation. Dates are considered 'too different' if there are too many typos AND the absolute difference in days is above the configured threshold.
Use the Date Too Different (Solutions) comparison to eliminate obvious record mismatches based on a date value.
This comparison does not support the use of result bands.
The following table describes the configuration options:
| Option | Type | Description | Default Value |
|---|---|---|---|
|
Maximum allowed typos |
Integer |
Tolerance to consider two dates similar if the Levenshtein Edit Distance between them [when represented in the form |
2 |
|
Maximum difference (days) |
Integer |
Tolerance to consider two dates similar if the absolute difference between them is less than or equal to the specified value. |
10 |
Example
This example demonstrates the effect of using the Date Too Different (Solutions) comparison.
Table 1-61 Example Options: Date Too Different (Solutions)
| Option | Setting |
|---|---|
|
Maximum allowed typos |
2 |
|
Maximum difference (days) |
2 |
Example results:
Table 1-62 Example Results: Date Too Different (Solutions)
| Value A | Value B | Comparison Result |
|---|---|---|
|
19991231 |
20000101 |
False |
|
19991231 |
20000105 |
True |
|
19831001 |
18931001 |
False |