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 |

## Comments

0 comments

Please sign in to leave a comment.