Conditions for Date Fields

To define a condition applied to a date field:

1. Select a date field.

   

2. Select the type of comparison (equal, not equal etc.).
3. Date fields allow you to use fixed and variable comparison values. Use the Fixed option to compare the value with a specific date or to a value entered by the user (if the Use as Parameter option is enabled). Use the Variable option to enter a date relative to the date the query is executed on. Select Field to compare the value with the contents of another field, see Variable Conditions, Comparing Field Contents and Parameters and Predefined Queries.
4. Click on OK to return to the query overview.