I am trying to set up a parameter query using ODBC-Microsoft Query to BMC Remedy The ODBC connection used in Excel-get external data is "AR System ODBC Data Source".


I want to pass a parameter to modified date field and get all the remedy tickets for which the modified date is<= to the passed parameter date.

I worked following instructions from link : http://dailydoseofexcel.com/archives...-data-queries/

So in MS query, SQL- the query looks like

WHERE ("table name"."Create Date">={ts '2014-10-01 00:00:00'}) AND ("table name"."Modified-date"<=?)

I am getting the data fetched from database in the MS query window, but unfortunately

When I click File-Return Data to Microsoft Excel, its showing an error: Driver]Parameter missing

I set the connection properties- parameter-Prompt for value using the following string.

Please help