[{TableOfContents }] !!!User Calc Operators An operator denotes an action that is to be taken on the operands indicated. There are several different categories of operators: !Arithmetic Operators For arithmetic operations the following operators are available: *[Add|ADD_OPERATOR] *[Subtract|SUB_OPERATOR] *[Multiply |MLT_OPERATOR] *[Divide|DIV_OPERATOR] *[Modulus|MOD_OPERATOR] *[Percent|PRC_OPERATOR] *[Maximum|MAX_OPERATOR] *[Minimum|MIN_OPERATOR] ---- !Rounding Operators After an arithmetic operation users may want to round the result using one of the following operators: *[Round Nearest|RDN_OPERATOR] *[Round Up|RDU_OPERATOR] *[Round Down|RDD_OPERATOR] *[Truncate|TRNC_OPERATOR] ---- !Conversion Operators Fields of one type may be converted to another with the following operators: *[Convert to a Date|DATE_OPERATOR] *[Convert to a Character|CHAR_OPERATOR] *[Convert to a Number|NUM_OPERATOR] *[Convert Wage to the Basis Indicated|WAGE_OPERATOR] ---- !Date Operators Date Operators available are: * [Day Portion of Date|DAY_OPERATOR] * [Month Portion of Date|MTH_OPERATOR] * [Year Portion of Date|YRS_OPERATOR] * [Days Between Dates|DBT_OPERATOR] * [Months Between Dates|MBT_OPERATOR] * [Years Between Dates|YBT_OPERATOR] ---- !Relative Date Operators Relative Date Operators give the ability to return the value of a date relative to another date. For example, if a Benefit plan should begin collecting premiums 1 month after hire date, a Relative Date Operator might be used to find the date that is Hire Date + 1 month. The variable defined must be a date. Operators available: * [Beginning of Day|BD_OPERATOR] * [Beginning of Week|BW_OPERATOR] * [End of Week|EW_OPERATOR] * [Beginning of Month|BM_OPERATOR] * [End of Month|EM_OPERATOR] * [Beginning of Year|BY_OPERATOR] * [End of Year|EY_OPERATOR] ---- !Comparison Operators Comparison Operators allow the UserCalc to compare two values. The operators available: * [Equal to|EQ_OPERATOR] * [Equal to If Null|EQNL_OPERATOR] * [Element Pay Line Values Operator|ELPL_OPERATOR] * [Pay Component Pay Line Value Operator|PCPL_OPERATOR] * [Not Equal to|NE_OPERATOR] * [Greater Than|GT_OPERATOR] * [Greater Than or Equal to|GE_OPERATOR] * [Not Greater Than|NG_OPERATOR] * [Less Than|LT_OPERATOR] * [Less Than or Equal To|LE_OPERATOR] * [Not Less Than|NL_OPERATOR] * [In List|IN_OPERATOR] * [Not in List|NN_OPERATOR] * [In Between|IB_OPERATOR] * [Not in Between|NB_OPERATOR] * [Like|LIKE_OPERATOR] [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.UC+OPERATORS] [{InsertPage page='Internal.UC+OPERATORS' default='Click to create a new discussion page'}] }]