Using Between Criteria

In this topic you learn how to add a criteria to the query in order to limit the query results to data that falls between two specified values.

In this example the query will display the employees whose original hire date is between January 1, 2004 and July 31, 2004. To do this you will use the "between" Condition Type.

Click the drop-down arrow for *Condition Type and select the between option.

Enter the desired information into the Date field.

Enter "010104".

Enter the desired information into the Date 2 field.

Enter "073104".

Note: The Criteria tab indicates ORIG_HIRE_DT between 2004-01-01 and 2004-07-31.

Note: In addition to the highest education level criteria established in the previous exercise, the query output now also reflects only those employees hired between 01/01/2004 and 07/31/2004.

Using Between Criteria

This completes Using Between Criteria.

Click the drop-down arrow for *Condition Type and select the between option.

Enter the desired information into the Date field.

Enter a valid value e.g. "010104".

Enter the desired information into the Date 2 field.

Enter a valid value e.g. "073104".

Click the Fields tab.

Click the Add Criteria button.

Click the between list item.

Enter the desired information into the Date field. Enter

a valid value

e.g.

"010104"

Enter the desired information into the Date 2 field. Enter

a valid value

e.g.

"073104"

Click the OK button.

Click the Criteria tab.

Click the Run tab.

DPIINFODIV

Using Between Criteria

Frame ID: