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.
expression < expression
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.
- 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.
Updated 04 Oct 2023
Did this page help you?