Hi,
I have a trouble to getting the work week from rows. Let's say I have a date and time format like this
![joshua_0-1582050202000.png joshua_0-1582050202000.png](https://community.jmp.com/t5/image/serverpage/image-id/21810i4D52F0792E5E65F3/image-size/medium?v=v2&px=400)
I tried following things by following the JSL manual @ page 150 and so forth but could not resolve this,
first I thought that I need to get rid of time values
dt << New Column( "Date_new",
Numeric, Continuous,
Formula(Format(:Name("Date"), "m/d/y")),
);
Then now I have the dates like this
![joshua_1-1582050456837.png joshua_1-1582050456837.png](https://community.jmp.com/t5/image/serverpage/image-id/21811i706FB3E3D4723BB3/image-size/medium?v=v2&px=400)
Next I tried to get ww of Date_new
dt << newcolumn("ww",Numeric, "Nominal",Week Of Year (Date MDY(:Date),3));
But got nothing! Why?
![joshua_2-1582050619470.png joshua_2-1582050619470.png](https://community.jmp.com/t5/image/serverpage/image-id/21812iEF561AF0F3B2DD78/image-size/medium?v=v2&px=400)