What is the right SQL expression for a parameter which is a StartDate or an EndDate?

[Former Member]

The SQL query is typed in a fixed query under Fixed Query Details on SAP MII Workbench. In the SQL query is a WHERE-clause "startDate >= '[StartDate]' AND endDate <= '[EndDate]' ". "startDate" and "endDate" are column names from the sql table.The SQL query is connected to a pie chart which is part of a Dashboard in SAP MII Self Service Composition Environment (SSCE). In the "Configure Query Parameters" menu two parameters from the group "Date Range" are added. These two Parameters are StartDate and EndDate. The Input Parameter for the two parameters are StartDate and EndDate, respectively. On the tab "Preferences" the two Parameters StartDate and EndDate are added. Both Parameters have the type "Time Stamp". If you click on the tab "Preview" a popup appears and StartDate as well as EndDate can be configured. A Default value in the format yyyy/MM/dd hh:mm:ss is prefilled in the text field. The field can also be filled by the use of a built-in datetime picker. An error message states "Start or end Dates cannot be parsed; enter a valid date format.

[former_member186998]

Is the database of this problem SQL Anywhere?
In that case, which version do you use?

I recommend that you post this question in Forum.

SAP SQL Anywhere Forum

Thanks,
Atsushi