Setting Date Parameter in an Excel Database Query

[honorbum]

I'm pulling data from an Oracle server (Remedy) via an Excel Database Query. I'm trying to set a criteria paramenter based on a date field in Remedy so the person accessing the report can be prompted to enter a "Start Date" and "End Date" of the date range of data. So far everything I've thought of doesn't work. It says >=[Enter Start Date] AND <=[Enter End Date] will work but it doesn't. Any suggestions?

 

[SkipVought]

Hi,

The STRING format that Oracle expects is
[tt]
dd-mmm-yyyy
[/tt]
such as 02-Nov-2005

and the SQL should look like

MyDate>='[Start Date]' And MyDate<='[End Date]'

with [tic] marks around the date.

Skip,

_{[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it!}

 

[honorbum]

Thanks Skip but didn't work.

 

[SkipVought]

Please post your SQL and the exact dates you entered.

Skip,

_{[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it!}