Operators And Literals

Special operators and literals that can be used within Databox Expressions.

These operators can be used to perform arithmetic and format all or parts of Numerical or Textual data:

Operators		Comments
Plus	+	Can be numeric addition or text concatenation: Number('1') + Number('1') = 2 or '1' + '1' = 11 Do NOT use for dates.
Minus	-	Do NOT use for dates.
Multiply	*
Divide	/
Percent	%
Parenthesis	()
Comma	,
Not equal	<>
Equals	=
Greater than	>	See the After function in Date Expressions
Less than	<	See the Before function in Date Expressions
Greater than or equal to	>=	Do NOT use for dates.
Less than or equal to	<=	Do NOT use for dates.
Logical and*	AND
Logical or*	OR
Logical not*	NOT
Text concatenate	&

IMPORTANT Do NOT use <,<=,>,>= or + when working with date values! See Date Expressions for specific date functions you can use for this.

Literals

Literals are used to represent various types of data, such as numbers, characters, strings, Boolean values, and more:

Literal Values
Boolean*	TRUE FALSE
Numbers	0-9 +/-/.
Text	'text' or "text"

* = Case insensitive