cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Schnipbt
Level I

Creating a New Month column pulling date from an existing column

Good Evening,

I am trying to script to take a date & time from column and create a new column that shows the month and year. the original column is in the format MM/DD/YY hh:mm on a 12 hour clock, and is a numeric continuous column. I would like the new column to be month-year.  Any help would be greatly appreciated.

2 REPLIES 2
txnelson
Super User

Re: Creating a New Month column pulling date from an existing column

You need to use the Month() function.

If your column is named Date, the formula would be

Month( :Date );
Jim
jthi
Super User

Re: Creating a New Month column pulling date from an existing column

If you have valid date column, you can right click on the column and create new formula column

jthi_0-1703191088342.png

This will then create you a new column which you can modify as needed

jthi_1-1703191112983.png

-Jarmo

Recommended Articles