Operands

List of Operators

Operand Left Operand Right Operand Result Comment
.MOD. INT INT INT Arithmetic MODULO operation
/, \* INT OR Float INT or Float Double Integer division and multiplication
+,- INT or Float INT or Float Double Integer addition and subtraction.
+ FLOAT TIME TIME Time shift.
+ TIME FLOAT TIME Time shift.
- TIME FLOAT TIME Time shift.
- TIME TIME FLOAT Time shift.
|| CHAR CHAR CHAR String concatenation.
.CONTAINS. CHAR CHAR BOOLEAN String containment. The operation is TRUE if the left operand contains the right operand as a substring anywhere within it.
.IN. Any List of operands all of the same type as the left operand BOOLEAN List inclusion. The operation is TRUE if the left operand is equal to any member of the list.
.AND. BOOLEAN BOOLEAN BOOLEAN A Boolean operator that takes two Boolean operands, and whose value is TRUE if and only if both of its operands are TRUE.
.OR. BOOLEAN BOOLEAN BOOLEAN A Boolean operator that takes two Boolean operands, and whose value is TRUE if either of its operands is TRUE.
.NOT. BOOLEAN BOOLEAN BOOLEAN A Boolean operator that takes a single Boolean operand and returns its inverse.
=, != Any Same as left BOOLEAN Equality.
<,>,<=,>= INT,FLOAT INT,FLOAT BOOLEAN Numeric comparison.
<,>,<=,>= TIME TIME BOOLEAN Date and time comparison
<,>,<=,>= BOOLEAN BOOLEAN BOOLEAN Boolean comparison (TRUE > FALSE).

Notes:

  • Arithmetic operations between dates use number of days as the FLOAT parameter (or result); e.g. 0.25 represents a time span of 6 hours.
  • Any operation with an ERROR argument MUST evaluate to ERROR. An EMPTY value may be compared (=,!=) against any value.
  • Appropriate casting functions (BOOL, CHAR, TIME, INT, FLOAT) MUST be applied to the parameters. If a function or an operator is applied to a data type different than shown in the above tables, the expression MUST evaluate to ERROR.
  • To simplfy arithematic operations, all integer and float parameters are converted to a double type and operations are performed and the result is always a double.