cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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