DATE Routine - trillium_discovery - trillium_quality - Latest

Inline Quality and Discovery

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:10:12.949492

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.