Date query issue

[nikolasp]

Hello,

I am doing a query into Oracle with MS-Access uisng the Query Design wizard where date is one of the parameters. The SQL View from the query window is:

SELECT PRICEVALUE.PRICEDATE, PRICEVALUE.DELIVDATE, PRICEVALUE.PRICEINDEX, PRICEVALUE.PRICE FROM PRICEVALUE WHERE (((PRICEVALUE.PRICEDATE)=#8/17/2006#) And ((PRICEVALUE.PRICEINDEX) Like 'ERCOT*'))

How do I convert the #8/17/2006# to the format Oracle understands (17-Aug-2006) while still enabling the user to enter any date?

Thanks,

Nick

 

[nikolasp]

anyone with some remote Oracle and Access experience who can answer this seemingly simple question?