Help

Extract months from dates in a multiselect field

Topic Labels: Formulas
241 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Brasted
7 - App Architect
7 - App Architect

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
4 Replies 4
Dan_Montoya
Community Manager
Community Manager

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.Screenshot 2024-02-03 at 9.48.59 AM.png

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

Dan_Montoya
Community Manager
Community Manager

Screenshot 2024-02-04 at 9.05.38 AM.pngScreenshot 2024-02-04 at 9.05.30 AM.png

Scott_Brasted
7 - App Architect
7 - App Architect

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

 

Image 2-5-24 at 9.14 AM.jpeg