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

Question

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

daultman · Answer

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.

Jonas_Rinne · Answer

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.