Metrohm viva 1.0 Manual - Manual (Page 54)

2.3 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
42 ￭￭￭￭￭￭￭￭
viva 1.0
Oper-
and1 Oper-
and2 Result Example Remark
Text Time Number "Metrohm" =
Time(1999;10;07) --> 0 Before the operation, the operand is con-
verted from Date/Time to Text (in this
example: "1999-10-07 00:00:00 UTC
+2"), afterwards the texts are compared
according to ASCII value (see Chapter
2.3.4.10, page 65).
Time Text Number Time(1999;10;07) =
"Metrohm" --> 0 The same rules apply here as for the previous
operation.
2.3.4.4.2 Greater than
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 > Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type. The result type is always a num-
ber (1 = true, 0 = false).
Examples
Oper-
and1 Oper-
and2 Result Example Remark
Operands of the same type:
Number Number Number 5 > 4 --> 1
4 > 5 --> 0
–
Text Text Number "Metrohm" > "AG" --> 1
"Aarau" > "Zug" --> 0
When making a comparison between two
texts, the ASCII value of the character
string is compared (see Chapter 2.3.4.10,
page 65). Attention: Uppercase and
lowercase letters have different values!
Time Time Number Time(1998;04;06) >
Time(1964;02;03) --> 1 (see Chapter 2.3.4.6.2, page 53)
Operands of a different type:
Number Text Number 1.2 > "Metrohm" --> 01.23 >
"1.2" --> 1 Before the relational operation, the Num-
ber is converted to Text, afterwards the
texts are compared according to ASCII
value (see Chapter 2.3.4.10, page 65).
Text Number Number "Metrohm" > 1.2 --> 1 The same rules apply here as for the previ-
ous operation.
Number Time Number 2.0 > Time(1999;10;07) --> 0 Before the comparison, the operand is
converted from Date/Time to a Number.