Returns the calculation dates associated with the expression in which #DATE is being used.

Within a benefit formula or an accrual basis, the dates are generally all of the plan year ends encompassed by the calculation plus any necessary additional dates such as the date of decrement and each benefit commencement date. The dates for a cash balance benefit formula component crediting interest more frequently than annually include each crediting period end. Within a service or salary transformation expressions, #DATE provides the sequential dates assembled to compute salaries and services, including month ends (only for Service), end of measurement periods, all of the dates in the referenced array fields, etc. (See Development of a transformation expression table  for additional details on included dates.) The exact values of #DATE for a given situation are available as the first column (the date column) of the detailed results output.

Syntax:

#DATE

Example:

Suppose a plan has a benefit which depends upon the number of years since the participant has transferred into the plan from another location. An annual hours transformation expression could be:

T_DT:= Date_of_transfer &	; Set T_DT to the date when the ; participant transferred in. By using ; Date_of_transfer in the expression, ; Date_of_transfer is added to the set of ; calculation dates
COND:= #IF (#DATE < T_DT)	; if the calculation date is before date ; of transfer, then set the condition to
#THEN 0	; 0 (if before transfer date)
#ELSE 1	; 1 (if transfer date or later)
#ENDIF &	; close #IF statement