# Logical expressions

Modified 2 years ago Nandini

Logical expressions are Boolean, meaning they return either a value of TRUE or FALSE.

Boolean values won’t display directly on a form. They are used in two situations:

#### Example fields

Here are some example fields to test out the logical expressions.

 FieldID Field type Example value num1 Number 6 num2 Number 4 text1 Text Pepper

#### Operators

There are six comparison operators you can use with logical expressions to compare fields. Some of them can only be used with certain data types.

 Name Symbol Data types Expression Value Equal to = Number, Currency, Date, Datetime1Text, User, Boolean num1 = num2 False Not equal to <>, != Number, Currency, Date, DatetimeText, User, Boolean num1 <> num2 True Less than < Number, Currency, Date, Datetime num1 < num2 False Less than or equal to <= Number, Currency, Date, Datetime num1 <= num2 False Greater than > Number, Currency, Date, Datetime num 1 > num2 True Greater than or equal to >= Number, Currency, Date, Datetime num1 >= num2 True

1. Timezones affect how you compare datetime fields. For example, this expression is true:

`Datetime(2018,1,1,12,20,00,"Asia/Kolkata") > Datetime(2018,1,1,12,20,00,"America/Chicago")`

#### Functions

 Function Description Syntax Value and TRUE if both boolean expressions are true.FALSE if either expression is false.Only two parameters are allowed. AND(num1 = 6, num2 = 4) True && Same as the AND function, but allows you to use multiple expressions. num1 = 6 && num2 = 4 && text1 = "Tony" False or TRUE if either boolean expression is true.FALSE if neither expression is true.Only two parameters are allowed. OR(num1 = 6, num2 = 10) True || Same as the OR function, but allows you to use multiple expressions. num1 = 6 || num2 = 10 || text1 = "Tony" True isBlank Check if a field is empty (TRUE) or has a value (FALSE).Can be used for any type of field. isBlank(text1) False False Shows the false boolean. false() False True Shows the true boolean. true() True Not Shows the opposite boolean. Not(num1 = 6) False