cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. ET on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

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

Extract the month, in text, from a JMP Date column

I can extract a month number from a date variable, but it is numeric only (1-12).  I know I can create a Match and force 1 = Jan, 5 = May, etc.  Is there a way I can use a simple formula to accomplish this?  Thank you.

 

I'm a retired dinosaur user - JMP 8

2 REPLIES 2

Re: Extract the month, in text, from a JMP Date column

Hi,

 

with up to date JMP Versions its very straightforward so this might help others searching for the same thing:

 

Right Click on the Date Column (date in my case) ->  New Formula Column -> Date Time -> Month Abbr.

 

This would be the jsl code for new formula column: 

Substr( Format( :date, "Monddyyyy" ), 1, 3 )

This might not work for JMP 8 but you can try it out. 

daultman
Level I

Re: Extract the month, in text, from a JMP Date column

Thank you for your very rapid reply.  I had previously searched the forum and found your suggested solution.  My version is ancient, and there is very limited right-clicking available.  I'm amazed my old program still works (Win11 and still alive).  I can easily extract the month out of the JMP date data, but is only numerical.  My backup is to create a Match formula and do the number-to-text conversion manually.  Not a big deal, really.  In my working years, we used JMP exclusively, mainly for DOE an exploratory analytics.  Now, I just play with it vs. EXCEL.  It's all good.

Recommended Articles