Choose Language Hide Translation Bar
Highlighted
Theresa
Level III

the data table show out 1 day after actual, see pic in below window

When i use this script the work week is correct, but the date is one day after the actual. such as, today is Friday, but see pic below , it show out the table name is ww13.6 not ww13.5. Could you help check where i should to edit to make it match? thanks  a lot.

 

script i use don't know how to correct it: We are using China Beijing time

dt << save(Route || "wizard all item-WW" ||Char( Week Of Year( Today() ) ) || "." || Char( Day Of Week( Today() ) ) ||".jmp");

 

 

Theresa_0-1585292181509.png

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: the data table show out 1 day after actual, see pic in below window

JMP weeks start on Sunday, so Friday is the 6th day of the week.  I suggest you just subtract 1 from the Day of Week function()

Char( Day Of Week( Today() ) - 1 ) 

 

Jim

View solution in original post

2 REPLIES 2
Highlighted
txnelson
Super User

Re: the data table show out 1 day after actual, see pic in below window

JMP weeks start on Sunday, so Friday is the 6th day of the week.  I suggest you just subtract 1 from the Day of Week function()

Char( Day Of Week( Today() ) - 1 ) 

 

Jim

View solution in original post

Highlighted
Theresa
Level III

Re: the data table show out 1 day after actual, see pic in below window

Thank you always
Article Labels

    There are no labels assigned to this post.