Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
renjithpl
Specialist
Specialist

Single Date in a variable when job rolled over for two days

Hi All, 

One of my QlikView job starts at Monday midnight and ends on Tuesday Morning .
I have a script to store into qvd year wise using a loop, so on Tuesday morning the last file gets stored, 

I doubt that when the last file is getting stored, the vDate variable changes to Tuesday date not the monday date. is that true ? I want one single date always. does the below code work, please suggest.

Eg.
Let vDate = reloadtime();
//or 
Let vDate = now(); 

For i = 2018 to 2020
Test:
Load * from tabl1;
Store Test into Test$(i)_$(vDate).qvd(qvd);

next ;

Out should be 

Test2018_12-15-2020.qvd
Test2019_12-15-2020.qvd
Test2020_12-15-2020.qvd.

Thanks

Renjith 

 

 

1 Solution

Accepted Solutions
marcus_sommer

Maybe setting the mode-parameter of the date-function explicitly is an option, means something like:

let vDate = today(2); 

- Marcus

View solution in original post

1 Reply
marcus_sommer

Maybe setting the mode-parameter of the date-function explicitly is an option, means something like:

let vDate = today(2); 

- Marcus