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

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

joshua — Tue, 18 Feb 2020 18:30:39 GMT

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

joshua — Tue, 18 Feb 2020 19:10:07 GMT

No answers yet ?

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

txnelson — Tue, 18 Feb 2020 19:11:05 GMT

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" format

joshua — Tue, 18 Feb 2020 19:24:12 GMT

This 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

stan_koprowski — Tue, 18 Feb 2020 20:53:12 GMT

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" format

Teehee_Tharan — Mon, 05 Feb 2024 05:51:04 GMT

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

hogi — Mon, 05 Feb 2024 20:31:57 GMT

And for "some" countries it is: