9min
< (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.
- > (greater-than)
- >= (greater-than-equals)
- <= (less-than-equals)