Online Documentation for SQL Query for InterBase/FireBird
Setting filter criteria values
Next, we need to specify value '10/1/2007' for the IS GREATER THAN operator.
Similarly, if, for example, we need to get the list of employees hired during the 9/1/2007 - 10/1/2007 term, we set the BETWEEN filter operator (this will add two empty value boxes to specify the inclusive range for the BETWEEN condition) and specify the range for the operator, i.e. the '9/1/2007' and the '10/1/2007' values in the corresponding value boxes.
It is possible to set the date value manually by typing it in, or via the date editor which is activated when you click the value box.
Editors used in value boxes are determined by the data type assigned to the corresponding columns.