Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
HI,
Try below
[lib:// (sns_USER)/FILES/HUB* .$(vFMONTH).XLS]