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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

get current date in reloading script

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.

9 Replies
vgutkovsky
Master II
Master II

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

Regards,

Not applicable
Author

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

What can be the reason?

vgutkovsky
Master II
Master II

Try this:


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



Regards,

Not applicable
Author

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
Master II
Master II

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

Cheers,

Not applicable
Author
















LET




LET




STORE



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


Not applicable
Author

That looks bad!!!


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


Not applicable
Author

It was helpful.

Thanks.

Anonymous
Not applicable
Author


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