Extract months from dates in a multiselect field

[Scott_Brasted]

I would like to extract the months from dates in a multiselect field. If I use Month(Months) I get NaN, If I use 

DATETIME_FORMAT(Months, 'MMMM') I get #ERROR!. 

Anyone know how to do this? 

Thanks, Scott

[Dan_Montoya]

Hi Scott -- 

Since you are using a multi-select field for dates extracting the individual month when there is more than one option selected creates a problem.  However, if you convert those dates to a linked table, the start month can easily be pulled.

[kuovonne]

Can you share a screen shot of your {Months} field so we can see example values?

[Dan_Montoya]

[Scott_Brasted]

Ok, so I sat back and looked at the data I was using and it came to me that I made a mistake when designing the table. The month data was poorly thought out. I changed it and now I do not need to get the month out. I did not need a compete mm/dd/yyyy in the field I only needed the month name. That made my need easy to get. Thanks for the help and answers. Best, Scott