Returns a duration (or elapsed time), such as an employee’s service measured from a particular date, e.g., ServiceDate, or adds a duration (or elapsed time) to current service as of the valuation date, e.g., CurrentService.

Syntax:

#SERVICE ServiceDate,

#SERVICE CurrentService.

ServiceDate and CurrentService must be accrual basis components linked to database fields. The field type must be either a date field or a numeric field.

Examples:

#SERVICE DOH

#SERVICE SVC95