Previous Topic: Grouping

Next Topic: Interface Components


Calculations Involving Date Fields

CA JARS takes the century into account when deriving various fields such as Elapsed Time and Turnaround Time that involve dates in the calculation. This ensures that correct values will be obtained for jobs, steps and transactions spanning the turn of the century.

Likewise, this product takes century into account in resolving the weekday and day of week keywords. Again, if the year is 59 or less, it is in the 21st century. If the year is 60 or higher, it is in the 20th century. So a YY/MM/DD date containing "97/01/01" generates a weekday value of Wednesday, while a date containing "00/01/01" generates a weekday value of Saturday, which is the correct day for January 1, 2000.