What Is Wrong with Two-Digit Years?
Currently, the date format of YYMMDD collates (sorts) correctly if the date is not after 1999. If the current date is December 10, 1996 for example, its numerical value (961210) is less than the value for December 10, 1997 (971210). At the turn of the century, dates in the YYMMDD format (or YYMM) will no longer sort correctly because the numeric values of dates in the 21st century will be sorted before date values in the 20th century. For example, the numeric value of 001210 (December 10, 2000) will come before 961210 (December 10, 1996) in the sort sequence.
