get current work week in string
Hi I need to pull the date from a constant changing folder name, the name is the year+curent WW e.g. 201817I 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())^"
);
it works when I run it on my PC but when I schedule it on a serv...
Eval Insert Into( WW );
dt = Open("\\.......\Reports\"||WW||"\.......xlsx");