Problem with a Date Parameter in MSQuery

I wonder if someone can help or advise if you agree that this could be an issue with JADE ODBC.

I am trying to use MSQuery in Excel 2003 to retrieve data from an External Database written in Jade using a date parameter. Using the syntax:

Between [Start Date] And [End Date]

where I want to retrieve the start and end dates from cells on an Excel Spreadsheet, however when I try to return the data to Excel it results in an error

"Expecting 'boolean primary'; found '(' at 457"

Any assistance would be appreciated,
Elizabeth

in order to use Dates as a parameter inside of Excel and MS Query through an ODBC driver you must create a date with this:

example : 07-april-2003

The cell must be in a text format for this to work also....

The month must be lowercase...

=LOWER(TEXT(DATE, "dd-mmmm-yyyy"))

This formula can be used for Oracle 8i problems....