How can I transfer a QlikView variable to a SQL statement?

[#1]

Hello

My document (qvw file) has a connection with a MS-SQL database.

In my script I use SQL statements like

Customer:
SQL
Select * from Customer;

Suppose I've a variable StartDate

SET StartDate=MakeDate(2012,01,01);

Is there a way to use the variable StartDate in a SQL statement?

Like

Customer:
SQL
Select * from Customer where Customer.Date >= StartDate;

I understand that in this example I better switch to QlikView syntax but I've fairly complex SQL statements that are hard to translate.

[Gysbert_Wassenaar · Accepted solution]

Try this:

Customer:

SQL

Select * from Customer where Customer.Date >= '$(StartDate)';

[nstefaniuk]

Hi, it's an issue of format.

do something like that:

vDateString=Year( StartDate )&num(Month( StartDate ))&Day( StartDate );

Customer:

SQL

Select * from Customer where Customer.Date >=

CONVERT(datetime, '$(vDateString'), 112)

[#4]

Thank you

[#5]

Thank you