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?