Convert Month to numeric Month

[Mamta123]

I have a column Month 

The Column has data like  January, February,  March , April, May etc.,

I need to convert it to numeric

January should be 1

February should be 2 etc.,

[tresesco · Accepted solution]

Try like:

Num(Month(Date#(Month, 'MMMM'))) as MonthNum