Converting the string of a month name to a number

[Craftor]

Hi all

Does anyone know how to convert the string of a month name to an integer e.g. if I have the string "JUNE" how can I change it to a "6"? Is there any function which does this?
I have tried the Month() function but that didn't work.

Any thoughts?

 

[MichaelRed]

MyMnth = 6
? Choose(MyMnth, "Janurary", "Feburary", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December&quot
? Format(MyMnth & "/1/1", "MMMM&quot
June
Your Choice

MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[Craftor]

Thank you that was a big help!!