Getting work week (WW) from "m/d/y h:m:s AM|PM" format

[#1]

Hi,

I have a trouble to getting the work week from rows. Let's say I have a date and time format like this 

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 

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?

[#2]

No answers yet ?

[#3]

dt << New Column( "Date_new",
Numeric, Continuous,
Formula(WeekOfYear(:date)),
);

All you need to do is to pull out the work week from the original :Date column.  Your formula for the "New Date" column was using a Format() function, which returns a character string.  But that issue can all be circumvented  with the above column definition.

[#4]

This is great and funny! nowwhere in the manual mention about `Formula(Weekofyear)` syntax.

[#5]

Hi @joshua,

Here is a link to the page in the documentation with the weekofyear function.

cheers,

Stan

[#6]

Just Open a new column in JMP and in the formula section find WEEK OF YEAR.

Week Of Year(date).

that's it....hope it helps.

[#7]

And for "some" countries it is:

Calculating WEEKOFYEAR() for weeks that start on a day other than Sunday or Monday