Please enable JavaScript to view this site.

The "LT" (less than) function determines whether a value is less than another value. If the first value specified is less than the second value specified, a true (1) is returned. Otherwise, a false (0) is returned. The LT function operates in the opposite manner as the GT function.

The less symbol (<) can also be used to perform this function and is the recommended method.

Category

Boolean

Syntax

LT(value1, value2) or value1 < value2

 

Parameter Descriptions

value1  -  This parameter specifies the first value to be used in the less than comparison. If this value is less than the second value, the result is true and a one (1) is returned. The value may be a field/column of a datastore, a literal value (i.e. ABC), a variable or the result of another Function.

value2  -  This parameter specifies the second value to be used in the less than comparison. The value may be a field/column of a datastore, a literal value (i.e. ABC), a variable or the result of another Function.

1 | 0 Indicates whether a TRUE (1) or FALSE (0) was returned from the ISDEC function.

Example

Compare each employees hours worked in a week (HRS_WORKED) against the constant 41 to determine if an employee is due overtime pay. If the condition is true, set variable OT_REQ to the constant Y. Otherwise, set the variable OT_REQ to the constant N.

IF HRS_WORKED < '41'

{

   OT_REQ = 'N'

}

ELSE

{

   OT_REQ = 'Y'

}