Skip to main content

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

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.


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



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

 


Reply