4 less than, Less than, Less than (<) – Metrohm tiamo 2.2 (ProcessLab) User Manual

Page 76

Advertising
background image

2.4 Formula editor

■■■■■■■■■■■■■■■■■■■■■■

60

■■■■■■■■

tiamo 2.2 (ProcessLab)

Oper-
and1

Oper-
and2

Result

Example

Remark

Time

Time

Number

Time(1998;04;06) >=
Time(1964;02;03) --> 1

(see Chapter 2.4.4.6.2, page 69)

Operands of a different type:

Number

Text

Number

1.2 >= "1.2" --> 11.2 >=
"Metrohm" --> 0

Before the relational operation, the Num-
ber
is converted to Text, afterwards the
texts are compared according to ASCII
value
(see Chapter 2.4.4.10, page 81).

Text

Number

Number

"Metrohm" >= 1.2 --> 1

The same rules apply here as for the previous
operation.

Number

Time

Number

2.0 >= Time(1999;10;07) -->
0

Before the comparison, the operand is con-
verted from the type Date/Time to a Num-
ber
.

Time

Number

Number

Time(1999;10;07) >= 2.0 -->
1

The same rules apply here as for the previous
operation.

Text

Time

Number

"Metrohm" >=
Time(1999;10;07) --> 1

Before the operation, the operand is con-
verted from the type Date/Time to Text
(here thus: "1999-10-07 00:00:00 UTC
+2"
), afterwards the texts are compared
according to ASCII value (see Chapter
2.4.4.10, page 81)
.

Time

Text

Number

Time(1999;10;7) >=
"Metrohm" --> 0

The same rules apply here as for the previous
operation.

2.4.4.4.4

Less 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 type Text, Number or Date/Time. The result type is always a number
(1 = true, 0 = false).

Examples

Oper-
and1

Oper-
and2

Result

Example

Remark

Operands of the same type:

Number

Number

Number

5 < 4 --> 0

4 < 5 --> 1

-

Advertising