extracting month

[#1]

Hello,

I have a column containing a timestamp in the following format:

Jan-01

Feb-01

How can I use formula to parse the month so that it would return:

Jan

Feb

I tried month(:Name("My-Column")) but it is giving me a red squiggly line. 

Thank you so much for your help!

[#2]

Is the column you reference as "My-Column" a JMP numeric Date/time column? Attaching a sample of the data would really help. Or even an image of the table

[#3]

Here is a screenshot of the data table. Thank you for looking into this! @txnelson 

[#4 · Accepted solution]

Your column is a character column, not a JMP numeric date column.  To create a column that has just the month part of the character string, use the formula

substr( :"Month-Year"n, 1, 3 );

The structure I used gives the same results as :Name("Month-Year), but the structure I used is the supported structure moving forward

P.S.  In the future when you provide an image of a data table, please provide the left hand panels of the data table.  They provide more detail about the columns.