cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
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