I am using microsoft query in excel. I am filtering the date of the database based on the content of two cells in excel ( See attached file below). However, the query is not returning any data. If I specify the date like 05/05/2012 or any other date it work ( the fomrat of the date in the database is 2010-05-05). But if I select the date based on the two cells in excel it does not return anything.
Microsoft query is this:
SELECT v_ccdata_0.bookingdate, v_ccdata_0.bookingnumber, v_ccdata_0.agentname, v_ccdata_0.pax_1_name
FROM cheapc.v_ccdata v_ccdata_0
WHERE (v_ccdata_0.bookingdate Between ? And ?)
New Compressed (zipped) Folder (2).zip