Load file with dynamic date in name

rolo_tomasi — Tue, 25 May 2021 06:53:08 GMT

Hello I need load file with name

HUB 06.05.2021.XLS - first two symbols are dynamic , need to load current month (like today is 22.05.2021)

let vFMONTH = date(TODAY(), 'MM.YYYY');

[lib:// (sns_USER)/FILES/HUB XX&'.'&$(vFMONTH).XLS] - how to declare xx?

Re: Load file with dynamic date in name

sasikanth — Tue, 25 May 2021 07:36:37 GMT

HI,

Try below

[lib:// (sns_USER)/FILES/HUB* .$(vFMONTH).XLS]