Skip to main content

Extract months from dates in a multiselect field

  • February 3, 2024
  • 4 replies
  • 47 views

Forum|alt.badge.img+17

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

Dan_Montoya
Forum|alt.badge.img+17
  • Employee
  • February 3, 2024

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
Forum|alt.badge.img+29
  • Brainy
  • February 4, 2024

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


Dan_Montoya
Forum|alt.badge.img+17
  • Employee
  • February 4, 2024


Forum|alt.badge.img+17
  • Author
  • Inspiring
  • February 5, 2024

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