Depending on the data type, you can compare values in separate columns or single columns against fixed values.
You can use basic comparison operators to perform comparisons on your data. In this example, the compareCol column is generated as the evaluation of
3 < 6, which is
For more information, see Comparison Operators.
Boolean values can be
false, so comparisons like the following can be applied to a Boolean set of values:
In the above case, the value in
Attendance is set to
true if the value in the
isSeated column is
true. Otherwise, the current value in
Attendance is used.
You can use the
DATEDIF function to compare two date values, as in the following, which compares the number of days between
NOTE: Both parameters of the
See DATEDIF Function.
See Compare Strings.