Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with let and today

Hi everybody.

Why i cant have this ?

LET Date = date(today());

I can do this SET Date =date(today());

BUT the problem is that i wanna to save this in this way

STORE tabe  INTO [..\Photo_$(Date).qvd];

and if i do the variable with set i'll have photo_date(today())

but if i do the same with let i'd have the date, not the function.

For example i did this with let and it worked, but i want to have only the normal date.

LET Date = year(Today())*100+month(Today());

1 Solution

Accepted Solutions
its_anandrjs

Hi,

Also for your problem for this script STORE table  INTO [..\Photo_$(Date).qvd];

You can try with store the path into the variable

SET Date2 = date(today());
Let Date3 = $(Date2);

  LET vPath = '..\';

STORE Tab2 into $(vPath)$(Date).Qvd;

Regards

Anand

View solution in original post

3 Replies
its_anandrjs

Hi,

You can try this way also by the below documents.

Store Qvd with timestamp value

Regards

Anand

its_anandrjs

Hi,

Also for your problem for this script STORE table  INTO [..\Photo_$(Date).qvd];

You can try with store the path into the variable

SET Date2 = date(today());
Let Date3 = $(Date2);

  LET vPath = '..\';

STORE Tab2 into $(vPath)$(Date).Qvd;

Regards

Anand

Not applicable
Author

Try with:

LET vDate = FLOOR(today());

or

LET vDate = DATE(today(), 'YYYYMMDD');



SET vQVD_File = Photo_$(vDate).qvd;

STORE tabe  INTO [..\$(vQVD_File)];