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

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

daultman — Fri, 27 Sep 2024 05:17:49 GMT

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

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

Jonas_Rinne — Fri, 27 Sep 2024 07:44:08 GMT

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.

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

daultman — Fri, 27 Sep 2024 07:59:31 GMT

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.