4D v18

Operators and values

Home

 
Home
4D v18
4D View Pro Reference
4D View Pro Formulas
Operators and values

Operators and values  


 

4D View Pro supports five types of data. For each data type, specific literal values and operators are supported.

Data typesValuesOperators
Number
1.2
1.2 E3
1.2E-3
10.3x
+ (addition)
- (subtraction)
* (multiplication)
/ (division)
^ (exponent, the number of times to multiply a number by itself)
% (percentage -- divide the number before the operator by one hundred)
Date10/24/2017
+ (date + number of days -> date)
+ (date + time -> date + time of day)
- (date - number of days -> date)
- (date - date -> number of days between the two)
Time10:12:10Duration operators:
+ (addition)
- (subtraction)
* (duration * number -> duration)
/ (duration / number -> duration)
String'Sophie' or "Sophie"
& (concatenation)
BooleanTRUE or FALSE-

The following operators can be used with two operands of the same type:

OperatorComparison
=equal to
<>different than
>greater than
<less than
>=greater than or equal to
<=less than or equal to

List of operators from most to least important:

OperatorDescription
()Parenthesis (for grouping)
-Negate
+Plus
%Percent
^Exponent
* and /Multiply and divide
+ and -Add and Substract
&Concatenate
=  > < >= <= <>Compare

When two or more different operands have the same name, 4D View Pro determines the type of each element according to the following order:

PriorityElement type
1Cell reference
2Cell name
34D View Pro function
4Project method
54D command
6Variable



See also 

4D View Pro Formulas

Previous page
Next page

 
PROPERTIES 

Product: 4D
Theme: 4D View Pro Formulas

 
PAGE CONTENTS 
Operators by data types
Comparison operators
Operator precedence
Operand precedence in formulas
 
HISTORY 

 
ARTICLE USAGE

4D View Pro Reference ( 4D v18)