Comment on page
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)
Inversion -
Less-than-or-equal <=
Last modified 1yr ago