With QUERY how to input a variable

I'm using query to extract data from an external database and I would like to
introduce a variable in my query
Example
select * from xxxxx
where datein between date1 and date2 where date1 and date2 are two variables

Check the parameter query section of this website:
http://www.rdg.ac.uk/ITS/info/traini...s/excel/query/

Does that help?

***********
Regards,
Ron


"Guillaume" wrote:

> I'm using query to extract data from an external database and I would like to
> introduce a variable in my query
> Example
> select * from xxxxx
> where datein between date1 and date2 where date1 and date2 are two variables