Functional Characteristics › 21st Century Support › Calculations Involving Date Fields

Calculations Involving Date Fields

CA JARS Wizard takes century into account when resolving the LODATE and HIDATE keywords. As with other operations involving dates, years of 59 or less are treated as being in the 21st century and years of 60 or more as being in the 20th century.Thus, in a file containing dates ranging from December 27, 1999 through January 7, 2000, LODATE is resolved as 12/27/99 and HIDATE as 01/07/00.

Likewise, CA JARS Wizard takes century into account in resolving the WEEKDAY and DAY OF WEEK keywords.Again, if the year is 59 or less, it is assumed to be in the 21st century. If the year is 60 or higher, it is assumed to be in the 20th century.So a MM/DD/YY date containing "01/01/97" generates a WEEKDAY value of WEDNESDAY, while a date containing "01/01/00" generates a WEEKDAY value of SATURDAY.