Comment on page

Greater-than-or-equal >=

Operator: >=
The Greater Than Or Equal operator >= is used to compare two values and to check whether a value is greater than, or equal to 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 greater than or equal to Value2. The result is False when Value1 is not greater 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 => Yes
1234 >= 2345 => No
"text2" >= "text1" => Yes
(Today() + '1d') >= UTCNow() => Yes
'12d' >= '20m' => Yes
'Product categories'.'Monitor' >= 'Product categories'.'Phone' => No (in the order of concepts, Monitor comes first)
[Data.CurrentUser] >= [OtherUser] => Yes (if current-user-id >= other-user-id)