1.3.3.8.24 Comparison: Date Difference
The Date Difference comparison determines the distance between two Date values. The difference may be expressed in different ways according to option settings; that is, it may be expressed as whole years, whole months, whole weeks, or whole days.
Use the Date Difference comparison to find dates that are close to each other, even if they are typographically different, and therefore would not match strongly using Date Edit Distance - for example to match 31/12/1999 as a close match to 01/01/2000.
This comparison supports the use of result bands.
Example Configuration
In this example, the Date Difference comparison is used on time series data to match all records that are within 30 days of each other (inclusive). Matches with a date difference of between 0 and 30 days (inclusive) can be found in a match rule:
Example Results
The following table shows example comparison results using the above configuration:
Table 1-63 Example Results: Date Difference
| Value A | Value B | Comparison Result |
|---|---|---|
|
01/01/2001 |
20/01/2001 |
20 |
|
25/12/2006 |
05/03/2007 |
71 |
|
30/11/1999 |
25/12/1999 |
26 |