Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Turning today() to a string and inserting it in a string in the load script

I am trying to load a new file every day. The file name is the same each day except for where today's date is. 

set Billing = '[lib://Billing]';
let t = Date(Date#(today(0)-22, 'M/DD/YYYY'), 'YYYYMMDD');
set newT = Text($(t));
let dateInText = '20200324';


Billing:
For Each File in FileList('$(Billing)/DataExport_Sales_$(dateInText)_050359.csv')

 

 Billing works, dateInText works, but newT, is what I am trying to get to work. I want newT to be where dateInText is. 

How can I get this to work? Or is there a better way?

 

Thank you,

Jacob

0 Replies