DATE Routine - trillium_discovery - trillium_quality - 17.1

Inline Quality and Discovery

Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery

The DATE routine compares two (2) date fields. The date format is YYYYMMDD.

Table 1. Scoring for DATE

Score

Description

100

Dates are equal and neither is zero.

75

One of the following conditions has been met:

Both years and months are equal, and not zero (20040214 versus 20040218).

Both months and days are equal, and not zero (20040214 versus 20030214).

Both years and days are equal and not zero (20040214 versus 20040414).

50

Either date is zero.

5

All other cases.

0

Difference between years is greater than or equal to ( >=) 16, and months and days are not equal.