By clicking on a ? question mark, you can input free form text :
- number constant
- string constant
Note on dates
When inputting dates, you are actually writing a string that will be converted to date on the target database where the query is made.
Note : in case of a Bufferized connection, it is the Buffer database.
This means that your date string may be interpreted wrong depending on the language of the target database.
A date format that is not ambiguous is advised, for example ISO date format.
To use an Alpana Parameter instead of a constant value, check Use Parameter and select a Parameter (it is also possible to create a new Parameter from here by clicking the list icon) :