Excel Query Wizard Date Query not working

Hi

So I inherited an excel sheet that has a query wizard query.

The long and short of it is when run you get a date range prompt to filter the data by. It was working fine but now its not. When you run it now it runs but displays all the rows including ones outside the date range.

SELECT slitemm.kind, slitemm.customer, slcustm.name, slitemm.dated, slitemm.item_no, slitemm.refernce, slcustem.ssdstate, slcustem.vatstate, slcustm.vat_type, slitemm.currency, slcustem.ecvatreg, slcustm.analysis_codes5, slitemm.analysis_codes2, slitemm.amount, slitemm.vat_amount, slitemm.currency_amount, slitemm.currency
FROM firefly.scheme.slcustem slcustem, firefly.scheme.slcustm slcustm, firefly.scheme.slitemm slitemm
WHERE slcustem.customer = slcustm.customer AND slitemm.customer = slcustem.customer AND slitemm.customer = slcustm.customer AND ((slitemm.kind='INV') AND (slitemm.dated>=? And slitemm.dated<=?) OR (slitemm.kind='CRN'))

The affected bit is (slitemm.dated>=? And slitemm.dated<=?) I have also used "between" "and" but get the same issue. I know how to do it in SQL and i think it is something to do with teh formatting of the data but the cells are all set to date range. As I said it was working before which makes it strange.

I should add this is a SQL query to a separate server the connection string is ok as it pulls the data fine.