topic get current date in reloading script in QlikView

get current date in reloading script

Wed, 12 May 2010 16:02:14 GMT

Hello,

I want to create QVD named bla_$(vDate).qvd

How can I get the current date into varriable vDate?

I will be glad to get a response ASAP!

Thanks,

Nimrod.

vgutkovsky — Wed, 12 May 2010 16:05:01 GMT

You could use function today(). So: LET vDate = today();

Regards,

Wed, 12 May 2010 16:14:28 GMT

Thanks but I still have not succed to concatenate the date to the file name.

What can be the reason?

vgutkovsky — Wed, 12 May 2010 16:19:34 GMT

Try this:


LET vDate = today();
LET vQVDName = 'bla_' & $(vDate) & '.qvd';
STORE tablename into $(vQVDName);

Regards,

Wed, 12 May 2010 16:24:14 GMT

great but I got the name:

bla_0.00020729684908789.qvd

How could I get the date in format 2010-12-05 (or in date format)

vgutkovsky — Wed, 12 May 2010 16:35:17 GMT

Oh, right. Change it to this: LET vDate = date(today());

Cheers,

Wed, 12 May 2010 16:47:43 GMT











 


 

LET
 


 
LET
 


 
STORE
 


 TABLE into $(vQVDName); vQVDName = 'BLAAAA_' & $(vDate) & '.qvd'; vDate = date(today(),'YYYYMMDD');

Wed, 12 May 2010 16:49:43 GMT

That looks bad!!!


LET vDate = date(today(),'YYYYMMDD');
LET vQVDName = 'BLAAAA_' & $(vDate) & '.qvd';
STORE TABLA into $(vQVDName);

Sun, 16 May 2010 07:26:26 GMT

It was helpful.

Thanks.

Anonymous — Thu, 12 Apr 2018 05:50:20 GMT

LET vDate = today();
LET vQVDName = 'bla_' & vDate & '.qvd';