NOT EQUAL (!=)
The operator '!=' compares two values and returns the boolean value TRUE if the left value is not equal to 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 |
| 5 + 5 != 10 | FALSE | boolean |