Comment on page
Greater-than >
Operator: >
The Greater Than operator
> is used to compare two values and to check whether a value is greater 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 greater than Value2.
The result is False when Value1 is not greater than 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.
35 > 35
=> No1234 > 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)Last modified 8mo ago