You are here: Processor Library > Matching > Comparisons > Exact Date Match

Comparison: Exact Date Match

The Exact Date Match comparison is a simple comparison that determines whether or not two date values match.

Use

Use the Exact Date Match comparison to find date matches, for example, when matching people using a Date of Birth identifier. The Exact Date Match comparison allows you to configure how tightly to match two dates - for example to ignore the year and century such that dates will match if the day and month are the same, so that for example "11/01/1901" will match "11/01/1970".

This comparison does not support the use of result bands.

Options

Option	Type	Purpose	Default Value
Match No Data pairs?	Yes/No	This option determines the result of a comparison when it compares two No Data (Null, or containing only whitespace characters) values for an identifier. If set to No, the comparison will give a 'no data' result when comparing a No Data value against another No Data value. If set to Yes, the comparison will give a full match (TRUE) when comparing a No Data value against another No Data value. A 'no data' result will only be returned if a No Data value is compared against a populated value.	No
Ignore day?	Yes/No	Ignore day allows the day part of the date to be ignored when matching. If set to Yes, the day will be ignored when matching. For example, "11/01/1975" will match "23/01/1975". If set to No, the day will be used when matching. For example, "11/01/1975" will match "11/01/1975", but "11/01/1975" and "23/01/1975" will not match.	No
Ignore month?	Yes/No	Ignore month allows the month part of the date to be ignored when matching. If set to Yes, the month will be ignored when matching. For example, "08/01/1975" will match "08/08/1975". If set to No, the month will be used when matching. For example, "08/08/1975" will match "08/08/1975", but "08/01/1975" and "08/08/1975" will not match.	No
Ignore year?	Yes/No	Ignore year allows the year part of the date to be ignored when matching. If set to Yes, the year will be ignored when matching. For example, "11/01/1901" will match "11/01/1875". If set to No, the year will be used when matching. For example, "11/01/1975" will match "11/01/1975", but "11/01/1901" and "11/01/1875" will not match.	No
Ignore century?	Yes/No	Ignore century allows the century part of the date to be ignored when matching. Note that the Ignore century option will only apply if Ignore year = No. If Ignore year = Yes, the entire year part of the date is always ignored. If set to Yes, the century will be ignored when matching. For example, "11/01/1901" will match "11/01/2001" (but "11/01/1975" will not match "11/01/1874") If set to No, the century will be used when matching. For example, "11/01/2001" will match "11/01/2001", but "11/01/1901" and "11/01/2001" will not match.	No
Time zone	Time Zone	Sets the time zone to use when comparing the two date/time values.	Director Time Zone

Example

Example configuration

In this example, the Exact Date Match comparison is used on a Date of Birth identifier to match people using their date and month of birth. The following options are specified:

Match No Data pairs? = No

Ignore day? = No

Ignore month? = No

Ignore year? = Yes

Ignore century? = any value (not applicable as Ignore Year = True)

Time zone = Director Time Zone

Example results

With the above configuration, the following table illustrates some comparison results:

Value A	Value B	Comparison result
11/01/1960	11/01/1960	TRUE (match)
11/01/1912	11/01/1970	TRUE (match)
11/08/1982	11/08/1960	TRUE (match)
11/01/1960	11/11/1960	FALSE (no match)
11/08/1960	08/11/1960	FALSE (no match)