Less Than or Equal | LESS_THAN_OR_EQUAL

Syntax

LESS_THAN_OR_EQUAL( [input], [other] )

Parameters

input
Any data may be used as the input.

other
Any data may be used as the other.

Return Value

TRUE if the VALUE is not greater than the OTHER. FALSE, otherwise.

Description

Determine if a value is not greater than another. Comparison is done structurally. If values of different types are provided, the comparison is done by type with the following precedence (from lowest to highest):

1. UNDEFINED
2. NULL
3. BOOLEAN
4. NUMBER
5. STRING
6. DATE
7. ARRAY / LIST
8. OBJECT / MAP

UNDEFINED values are always considered equal. NULL values are also always considered equal. FALSE is less than TRUE. NUMBER values are compared as one would expect. STRING values are compared alphanumerically. DATE values are compared normally. ARRAY values are compared item by item where the first non-equal value is the result. MAP value are currently always considered equal, but this is likely to change in a future update, and should not be relied upon.

Examples

LESS_THAN_OR_EQUAL(1, 2) # returns TRUE

LESS_THAN_OR_EQUAL(2, 1) # returns FALSE

LESS_THAN_OR_EQUAL(1, 1) # returns TRUE

LESS_THAN_OR_EQUAL("abc", "abd") # returns TRUE

LESS_THAN_OR_EQUAL([1, 2, 3], [1, 2, 3]) # returns TRUE

LESS_THAN_OR_EQUAL([1, 2, 3], [1, 2, 4]) # returns TRUE

LESS_THAN_OR_EQUAL([1, 2, 3], [1, 2]) # returns FALSE

LESS_THAN_OR_EQUAL([1, 2, 3], [1, 3]) # returns TRUE

LESS_THAN_OR_EQUAL(null, null) # returns TRUE