Variables

[Peter Riggs]

Hi

Hopefully someone can show me where I'm going wronmg here. If I enter the following into MySQL editor, the query will run correctly and pass the date values into the query,

set @from_date ='2012-12-01',
@to_date ='2013-01-01';
select vw_all_companies.Full_name as 'Logged Calls by Client', count(*) as 'Number'
from vw_call_log_all , vw_all_companies
where vw_call_log_all.customer_company_id = vw_all_companies.id
and open_date >= @from_date and open_date < @to_date


however, when I try to embed the same query into Excel, it will not run and shows the error

'The following data range failed to refresh...'

If I manually eneter in the dates, it query runs successfully. What am I doing wrong here?

Many thanks



Edited 1 time(s). Last edit at 11/04/2013 03:27AM by Peter Riggs.