Extract the month, in text, from a JMP Date columnI 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
WindowsRe: Extract the month, in text, from a JMP Date columnHi,
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 columnThank 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.
