get current work week in string

[#1]

Hi 

I need to pull the date from a constant changing folder name, the name is the year+curent WW e.g. 201817

I have the following JSL 

if ((day of week(today()))==1,
WW = "^year(today())^^week of year(today())-1^",
WW = "^year(today())^^week of year(today())^"
);

Eval Insert Into( WW );

dt = Open("\\.......\Reports\"||WW||"\.......xlsx");

it works when I run it on my PC but when I schedule it on a server the script not running - anyone has idea way?

[#2]

Have you tried pulling from the server?

path = "\\.......\Reports\"||WW||"\.......xlsx";
show(path);
dt = open(path);

[#3]

it was a server access issue at the end, thanks for helping