Previous Topic: 21st Century Support

Next Topic: Selection, Rejection, and Compares Involving Date Fields


Sorting on Date Fields

When a date field is specified on the Sort Control Statement, CA JARS takes the century into account and makes an adjustment in setting up the Sort field. If the year is 59 or less, it is treated as being in the 21st century. If the year is 60 or higher, it is treated as being in the 20th century. Thus, when performing a sort in ascending sequence, this product sorts a YY/MM/DD field containing "99/12/31" (December 31, 1999) ahead of a field containing "00/01/01" (January 1, 2000).