Using external data in excel

[Tracey]

Within an external qeury when I create a parameter to allow a to andfrom date
to be entered I get an error message saying that the date (in both the from
and to parameter) is an invalid column name.

Can anybody help wth this