Previous Topic: Sorting on Date Fields

Next Topic: Grouping


Selection, Rejection, and Compares Involving Date Fields

When performing selection or rejection based on a date field via the CRITERIA statement, CA JARS takes the century into account. If the year portion of the date contains a value of 59 or less, it is treated as being in the 21st century. If the year is 60 or more, it is treated as being in the 20th century.

Thus, for selection, rejection, or comparison purposes, a date field containing "00/01/01" (January 1, 2000) compares high against a constant of "99/12/31" (December 31, 1999).