how to convert Date format "January" to "01"

[jim_chan]

Hi guys,

I have a month column called " Monthname" , it has value as "January, Feb,March,April......".

I want to change the value to instead of January, how to convert it to "01" ?

rgds,

Jim

[jim_chan]

thank  you Jonathan! i got it!