Less-than <

Operator: <

The Less Than operator < is used to compare two values and to check whether a value is less than the other. The < operator can be used to compare values of the following types:

• text

• number

• duration

• datetime

• concept

• reference

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The result of the < operator is true or false. The result is True whenValue1 is less than or equal to Value2. The result is False when Value1 is not less than or equal to Value2.

• number <= number

• text <= text returns (alphabetical comparison, case insensitive)

• datetime <= datetime

• duration <= duration

• concept <= concept (applies to the order of concepts)

• reference <= reference

If any of the operands is unknown, the result is also unknown. If operands are not of the same type, the "expression type mismatch" warning is displayed.

value1 < value2

35 < 35 => No

234 < 2345 => Yes

"text1" < "text2" => Yes

Today() < UTCNow() => Yes

'12d' < '350m' => No

'Product categories'.'Monitor' < 'Product categories'.'Phone' => Yes (in the order of concepts, Monitor comes first)

[Data.CurrentUser] < [OtherUser] => Yes (if current-user-id < other-user-id)