248102_en-US

liliconcom

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

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?

 

 

 

 

 

 

 

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

Hi @joshua,

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

cheers,

Stan

Re: Getting work week (WW) from "m/d/y h:m:s AM|PM" formatThis is great and funny! nowwhere in the manual mention about `Formula(Weekofyear)` syntax.Re: Getting work week (WW) from "m/d/y h:m:s AM|PM" format

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.

Re: Getting work week (WW) from "m/d/y h:m:s AM|PM" formatNo answers yet ?Re: Getting work week (WW) from "m/d/y h:m:s AM|PM" format

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.

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

And for "some" countries it is:

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