Choose Language Hide Translation Bar
Highlighted
AdamChoen
Level III

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. 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?

 

 

Thanks, Adam
2 REPLIES 2
Highlighted
vince_faller
Super User

Re: get current work week in string

Have you tried pulling from the server?

 

path = "\\.......\Reports\"||WW||"\.......xlsx";
show(path);
dt = open(path);
Vince Faller - Predictum
Highlighted
AdamChoen
Level III

Re: get current work week in string

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

Thanks, Adam
Article Labels

    There are no labels assigned to this post.