< (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)