Adding a constant

Constant value

By clicking on a ? question mark, you can input free form text :

• number constant
• string constant
  

Note on dates

*To input a constant date, it is strongly advised to use the ISO date format :
YYYY-MM-DD for dates, for example 2019-12-25
YYYY-MM-DDThh:mm:ss.sss for datetimes, for example 2019-12-25T23:59:59.999

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.

Dashboard Parameter

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) :