Microsoft Query prompt

D

davel

Hi,

I'm using MS Excel and MS Query to access Oracle tables.
When I set the Criteria Field to year of date and set
Value to a specific year (e.g. 2003) the query runs fine.
When I set Value to prompt, run the query, and enter year
(e.g. 2003)at prompt I get a "Syntax error in date" msg.
The query SQL is:

SELECT MV_AHS_TRIP.TRIP_START_DATE
FROM MARVIN.MV_AHS_TRIP MV_AHS_TRIP
WHERE (TO_CHAR(TRIP_START_DATE,'YYYY')=?)

What should I enter at the prompt or what should the year
function be?

thanks

Davel
 
Top