Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 12, 2017 at 07:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded