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.

value1 > value2

35 > 35 => No

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)