This page (revision-24) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
24 26-Nov-2021 10:22 2 KB RForbes to previous
23 26-Nov-2021 10:22 2 KB RForbes to previous | to last
22 26-Nov-2021 10:22 2 KB JEscott to previous | to last
21 26-Nov-2021 10:22 2 KB JEscott to previous | to last

Page References

Incoming links Outgoing links
UC OPERATORS
UC OPERATORS

Version management

Difference between version and

At line 8 changed 9 lines
For arithmetic operations the following operators are available:
* ADD [Add|ADD_OPERATOR]
* SUB [Subtract|SUB_OPERATOR]
* MLT [Multiply |MLT_OPERATOR]
* DIV [Divide|DIV_OPERATOR]
* MOD [Modulus|MOD_OPERATOR]
* PRC [Percent|PRC_OPERATOR]
* MAX [Maximum|MAX_OPERATOR]
* MIN [Minimum|MIN_OPERATOR]
*[Add|ADD_OPERATOR]
*[Subtract|SUB_OPERATOR]
*[Multiply |MLT_OPERATOR]
*[Divide|DIV_OPERATOR]
*[Modulus|MOD_OPERATOR]
*[Percent|PRC_OPERATOR]
*[Maximum|MAX_OPERATOR]
*[Minimum|MIN_OPERATOR]
At line 20 changed 5 lines
After an arithmetic operation users may want to round the result using one of the following operators:
* RDN [Round Nearest|RDN_OPERATOR]
* RDU [Round Up|RDU_OPERATOR]
* RDD [Round Down|RDD_OPERATOR]
* TRNC [Truncate|TRNC_OPERATOR]
*[Round Nearest|RDN_OPERATOR]
*[Round Up|RDU_OPERATOR]
*[Round Down|RDD_OPERATOR]
*[Truncate|TRNC_OPERATOR]
At line 26 removed one line
----
At line 28 changed 5 lines
Fields of one type may be converted to another with the following operators:
* DATE [Convert to a Date|DATE_OPERATOR]
* CHAR [Convert to a Character|CHAR_OPERATOR]
* NUM [Convert to a Number|NUM_OPERATOR]
* WAGE [Convert Wage to the Basis Indicated|WAGE_OPERATOR]
*[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]
At line 34 removed one line
----
At line 36 changed 7 lines
Date Operators available are:
* DAY [Day Portion of Date|DAY_OPERATOR]
* MTH [Month Portion of Date|MTH_OPERATOR]
* YRS [Year Portion of Date|YRS_OPERATOR]
* DBT [Days Between Dates|DBT_OPERATOR]
* MBT [Months Between Dates|MBT_OPERATOR]
* YBT [Years Between Dates|YBT_OPERATOR]
* [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]
At line 44 removed one line
----
At line 49 changed 7 lines
* BD [Beginning of Day|BD_OPERATOR]
* BW [Beginning of Week|BW_OPERATOR]
* EW [End of Week|EW_OPERATOR]
* BM [Beginning of Month|BM_OPERATOR]
* EM [End of Month|EM_OPERATOR]
* BY [Beginning of Year|BY_OPERATOR]
* EY [End of Year|EY_OPERATOR]
* [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]
At line 57 removed one line
----
At line 62 changed 21 lines
* EQ [Equal to|EQ_OPERATOR]
* EQNL [Equal to If Null|EQNL_OPERATOR]
* ELPL [Element Pay Line Values Operator|ELPL_OPERATOR]
* PCPL [Pay Component Pay Line Value Operator|PCPL_OPERATOR]
* NE [Not Equal to|NE_OPERATOR]
* GT[Greater Than|GT_OPERATOR]
* GE [Greater Than or Equal to|GE_OPERATOR]
* NG [Not Greater Than|NG_OPERATOR]
* LT [Less Than|LT_OPERATOR]
* LE [Less Than or Equal To|LE_OPERATOR]
* NL [Not Less Than|NL_OPERATOR]
* IN [In List|IN_OPERATOR]
* NN [Not in List|NN_OPERATOR]
* IB [In Between|IB_OPERATOR]
* NB [Not in Between|NB_OPERATOR]
* LIKE [Like|LIKE_OPERATOR]
----
![Notes|Edit:Internal.UC+OPERATORS]
[{InsertPage page='Internal.UC+OPERATORS' default='Click to create a new notes page'}]
* [Equal to|EQ_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]
This page (revision-24) was last changed on 26-Nov-2021 10:22 by RForbesTop