< (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 > (greater than) docid\ kc0htlkxuvbamz x6qft9 >= (greater than equals) docid\ ye9gwbz itgpxtbdzxd a <= (less than equals) docid\ ibs4w l1pwa6xmswyvujq