Carrot reference
Operators

< (less-than)

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

Syntax

expression < expression

Sample usage

tenure < 3 returns all records where tenure is less than 3.

('2021-01-01') < ('2020-01-01') evaluates to false.

base < 100000 returns all records where base is less 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