The operator LESS THAN (<) is used to check if a value is strictly less than another. It returns true if the first value is smaller than the second, and false if it is equal to or greater. This operator is commonly used when you need to verify if a value meets a lower limit or threshold.
➡️ Display Name :
➡️ Syntax:
Example:
In this example, the condition will be true if the age is less than 18, and false if the age is equal to or greater than 18.
- 1 value 🟡 : age is the first value to compare.
- 1 operator 🟣 : < checks if the age is strictly less than the second value.
- 1 value 🟡 : 18 is the reference value to which the age is compared.
🟰 Expected Result:
- If age < 18, the condition is true.
- If age >= 18, the condition is false.
💡 Comparison with other operators:
Unlike the operator LESS THAN OR EQUAL TO (<=), which includes the limit value, LESS THAN (<) only works for strictly less comparisons, excluding equal values.
Before You Start
Getting Started with Formulas
New formulas in Timetonic allow you to transform, calculate, and manipulate the information stored in your columns by combining several functions...
Or Continue With
Formula Glossary View
Quickly find the function or operator you're looking for or simply discover and learn how to use them…