Setting Date in the load statement

[#1]

Hi,

I tried setting the date in the load statement as below

Set vName = date(Today();'YYYYMMDD');

OLDEDB connect to .......

Test_daily:

SQL query statement................

.................................................

store Test_daily into Test_daily_$(vName).qvd

but this comes with a error :

Unknown file format specifier Today( store Test_daily into Test_daily_date(Today();'YYYYMMDD');

Any suggestions.

Thanks-

[luciancotea]

LET Set vName = date(Today();'YYYYMMDD');

[stephencredmond]

Should be a comma, no?

LET vName = date(Today(),'YYYYMMDD');

Use LET instead of SET because it assigns the calculated value to the variable whereas SET just assigns the text on the right of the = to the variable.

Regards,

Stephen

Stephen Redmond is author of QlikView for Developer's Cookbook

He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.

Follow me on Twitter: @stephencredmond

[#4]

Changing SET to LET worked perfectly.

Thank you.