1.3.4.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 yyyyMMdd] is less than or equal to than the specified value.	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