DateFormula provides for the definition and storage of a simple, but clever, set of constructs to support the calculation of runtime-sensitive dates. A DateFormula data type is stored in a non-language dependent format, thus supporting multi-language functionality. A DateFormula data type is a combination of:
- Numeric multipliers (for example 1, 2, 3, 4, and so on)
- Alpha time units (all must be uppercase)
- D for a day
- W for a week
- WD for day of the week, that is day 1 through day 7 (either in the future or in the past, not today), Monday is day 1, Sunday is day 7
- M for calendar month
- Y for year:
- CM for current month, CY for current year, CW for current week
- Math symbols interpretation:
- + (plus) as in CM + 10D means the current ...
