Home
>
Expression Operators
Expression Operators
ProVal has the following types of operators:
Arithmetic Operators
#ABS
#CEILING
#DIV
#EXP
#FLOOR
#LN
#INT
#LOG
#MAX
#MIN
#MOD
#ROUND
#SIGN
#ZMINUS
Date Operators
Entering a date
Duration
#DATEMINUS
#DATEPLUS
#MONTHDIF
#YEARDIF
#DAY
#MONTH
#YEAR
#BEGMTH
#ENDMTH
#NEXTBEGMTH
#MONTHROUND
Relational Operators
#IN
#NOTIN
Pattern
#IN vs. = (equals)
Logical Operators
#AND
#NOT
#OR
If Then Else Operators
Miscellaneous Operators
Assignment
Statement separator
#ERRORS
#MV
#SUBSET
Benefit Formula Operators
#MAXBEN (U.S. law)
#CANMAX (Canadian law)
#EQCY
#GECY
#GTCY
#LECY
#LTCY
#NECY
#ENTRYYEAR
#VALYEAR
#VALTYPE
#DECAGE (OPEB mode)
#DECPTS (OPEB mode)
#DECSVC (OPEB mode)
#DECYEAR (OPEB mode)
#PMTAGE (OPEB mode)
#MEMPMTAGE (OPEB mode)
#PMTYEAR (OPEB mode)
#ReserveEE (universal mode)
#ReserveER (universal mode)
#ReserveEEPS (universal mode)
#ReserveERPS (universal mode)
#NoAttrib
#DECSTOP (German mode)
#NORMToNRB (German mode)
Accrual Basis Operators
#AVGWB (U.S. law)
#AVGYMPE (Canadian law)
#AVGYAMPE (Canadian law)
#BBG (German law)
#BBGKV (German law)
#CANMAX (Canadian law)
#CVCP (U.S. law)
#ENTRYYEAR
#FAS
#LEL (U.K. law)
#MAXBEN (U.S. law)
#MAXSAL (U.S. law)
#PIA (U.S. law)
#SALARY
#SERVICE
#SSWB (U.S. law)
#SVR (German law)
#YMPE (Canadian law)
#YAMPE (Canadian law)
COLA Expression Operators
Character Operators
#CONCAT
#FIND
#LEFT
#LEN
#RIGHT
DC Formula Operators
#CATCHUPLIM
#CONTLIM
#DEFERRALS
#DEFLIM
#FIRSTDAY
#LASTDAY
#MAXSAL
#OTHERDATE
#PYBEG
#PYEND
#SALARY
#SSWB