help with jsl to convert table column from datetime yyyy/mm/dd hh:mm:ss to work week?

rrtx_mike

Hi All,

I am looking for help to convert a table column from date time to work week, can you help me with a script to accomplish this conversion?

My data format is: 2016/03/21 8:59:27.921 PM and I'd like to convert this to calendar work week. I am using JMP 12.

Thank you!

txnelson

Use the JMP function:  Week of Year();

You will either have to create a new column with the above function as the formula for the column, or to replace the values within the same column the following script will do it:   Assume that the target column is named......MyDate

Names Default to Here(1);

dt=current data table();

For Each Row(

     MyDate=Week of Year(MyDate);

);

dt:MyDate << format("Best",5);