Comparison Templates

  • Updated

Comparison functions evaluate to Boolean by comparing values to the left and right of the operator.

Function Template format Return type
is among <field> is among <value>,
<value>, [add value]
*List of values of same
data type as left side of
comparison
Boolean
is not among <field> is not among
<value>, <value>, [add
value]
*List of values of same
data type as left side of
comparison
Boolean
is at least <numeric> is at least
<numeric expression>
Boolean
is at most <numeric> is at most
<numeric expression>
Boolean
is between <date or numeric> is
between <date or numeric
expression> and <date or
numeric expression>
Boolean
is not between <date or numeric> is not
between <date or numeric
expression> and <date
numeric expression>
Boolean
is equal to <Field> is equal to
<value>
*value of same data type
as left side of comparison
Boolean
is Not Null <field> is not NULL  Boolean
is NULL <field> is NULL Boolean
is not empty <field> is not empty Boolean
is a number <value> is a number Boolean
is greater than <numeric> is greater than
<numeric expression>
Boolean
is greater than or equal to <numeric> is greater than
or equal to <numeric
expression>
Boolean
is less than <numeric> is less than
<numeric expression>
Boolean
is less than or equal to <numeric> is less than or
equal to <numeric
expression>
Boolean
is after <date> is after <date
expression>
Boolean
is on or after <date> is on or after <date
expression>
Boolean
is not after <date> is not after <date
expression>
Boolean
is before <date> is before <date
expression>
Boolean
is not before <date> is not before <date
expression>
Boolean
is on or before <date> is on or before
<date expression>
Boolean
is null or empty <field> is null or empty Boolean
is not null or empty <field> is not null or empty Boolean
is TRUE <Boolean> is TRUE Boolean
is FALSE < Boolean> is FALSE Boolean

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.