Carrot reference
Operators

> (greater-than)

Returns all records where the value of one expression or field is greater than the value of another expression or field.

Syntax

expression > expression

Sample usage

tenure > 3 return all records where tenure is greater than 3.

('2021-01-01') > ('2020-01-01') evaluates to true.

base > 100000 returns all records where base is greater than $100,000.

Supported data types

  • Number
  • Percent
  • Money
  • Date
  • String
  • Shares

Note: When a Money value is compared to a Number, the Money value is compared as an amount in the Org's primary currency.

See also