topic Re: Setting Date in the load statement in QlikView

Setting Date in the load statement

Wed, 10 Jul 2013 19:36:54 GMT

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-

Re: Setting Date in the load statement

luciancotea — Wed, 10 Jul 2013 19:41:50 GMT

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

Re: Setting Date in the load statement

stephencredmond — Wed, 10 Jul 2013 19:44:30 GMT

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

Re: Setting Date in the load statement

Wed, 10 Jul 2013 20:10:44 GMT

Changing SET to LET worked perfectly.

Thank you.