Modifying Action Diagrams › Understanding Built-In Functions › Calculation Assumptions and Examples for Date Built-In Functions

Calculation Assumptions and Examples for Date Built-In Functions

Since months and years do not contain equal numbers of days, date calculations involving these units are adjusted to conform to common sense standards rather than to pure mathematical accuracy. This section presents assumptions made to the output results for the *DATE INCREMENT and *DURATION built-in functions. A set of examples explain possibly confusing results and show recommended function usage.

CA 2E makes the following assumptions to provide consistent results for the *DATE INCREMENT and *DURATION functions independent of the input value:

• Duration between "today" and "today" equals 0 days.
• Duration between "today" and "tomorrow" equals 1 day.
• Since mathematical necessity requires that either the Start date or the End date not be counted when calculating date duration or date increment, CA 2E does not count the Start date (*Date2).

  Note that this is significant only when you have explicitly excluded specified dates from calculations using selection parameters or a date list.