You can build an expression that consists of more than one comparison. This is referred to as a compound expression.
Suppose you want to search for all active employees who were hired before June 1, 2023. Here we need to create two comparisons: the first one tells the system to find employees who have an (A)active status; the second comparison tells the system that of those active employees, it should find only those who were hired before 6/01/2023.
Using the Expression Builder, you would build the following compound expression:
PE.P_ORIGHIRE<{06/01/2023 AND PE.P_ACTIVE="A"
The two expressions are divided with the word AND that tells the system to find the employees who satisfy both comparisons
If you used the word OR to divide the two expressions, Sage HRMS would find two sets of employees: those who were hired before 6/01/2023 and those who have an Active status, resulting in more employees than if you used AND.