cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
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
vince_faller
Super User (Alumni)

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
AdamChoen
Level III

Re: get current work week in string

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

Thanks, Adam