April 2017
Intermediate to advanced
706 pages
17h 8m
English
CALCDATE allows us to calculate a date value assigned to a Date data type variable. The calculation is based on a Date Expression applied to a Base Date (Reference Date). If we don't specify a BaseDateValue, the current system date is used as the default date. We can specify the BaseDateValue either in the form of a variable of data type Date or as a Date constant.
The syntax for CALCDATE is as follows:
DateVariable := CALCDATE ( DateExpression [, BaseDateValue])
There are a number of ways in which we can build a DateExpression. The rules for the CALCDATE function, DateExpression, are similar to the rules for DateFormula, which is described in Chapter 3, Data Types and Fields.
If there is a CW, CM, CP, CQ, or CY (Current Week, ...
Read now
Unlock full access