Re: Variables

[Peter Riggs]

Hi

Thanks for answering. I'm using Excel 2010, and connecting to the database via ODBC. Within Excel I am using the data connection wizard to create the links between Excel and the database.

What I have is a query that has a to and a from date field that is embedded in 8 times. What I want to avaoid is typing in these dates 8 times within the query and then when I change the date range, overwriting them 8 times. The ability to use something like
set @from_date ='2012-12-01',
@to_date ='2013-01-01';
would be so helpful. Interestingly, this does work within MySQL Workbench, so any ideas round this would be greatfully received.

In an even more ideal world, I would like not to have to open the query each time I want to amend it, and have the query reference 2 dates within 2 cells on the spreadsheet.

Anyway, thanks for your response



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