Load file with dynamic date in name

[rolo_tomasi]

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?

[sasikanth · Accepted solution]

HI, 

Try below 

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