topic get current work week in string in Discussions

get current work week in string

AdamChoen — Wed, 25 Apr 2018 11:40:57 GMT

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?

Re: get current work week in string

vince_faller — Wed, 25 Apr 2018 17:16:32 GMT

Have you tried pulling from the server?

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

Re: get current work week in string

AdamChoen — Fri, 04 May 2018 08:53:51 GMT

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