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
Bookmarks