Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Setting Date in the load statement

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-

3 Replies
luciancotea
Specialist
Specialist

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

stephencredmond
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

Changing SET to LET worked perfectly.

Thank you.