LESS (<)
The operator '<' compares two values and returns the boolean value TRUE if the left value is smaller than the right value and FALSE otherwise.
Syntax
value1 < value2 |
Inputs
value1 - Number, date or attribute of some type of number or date.
value2 - Number, date or attribute of some type of number or date.
Return type
boolean
Examples
| Expression | Result | Type |
|---|---|---|
| 1 < 2 | TRUE | boolean |
| 1.0 < 1.0 | FALSE | boolean |
| DATE( 2012 , 1 , 1 ) < TODAY | TRUE | boolean |
| 2000 < YEAR( TODAY ) | TRUE | boolean |