Month (mmm) to Month(m)

Question

Dear All, 
 I have local variable local!month_selected, which will be having values of month in "mmm" format. Is there any inbuild function to get the month format as "m", 
 (E.g) Input value will be "AUG" and expected output should be "8" 
 
 Please help me.

Sunil Mohan · Accepted Answer

Thanks Amit, it help me

Amit Mishra · Answer

Hi Sunil, your problem can be solved with exactly below code. 
 load( local!date: "01-" & ri!mon & "-" & year( today() ), { month(todate( local!date),{}) } ) 
 
 Thanks.

Anna Pol · Answer

You can use datetext(todate(local!date),"M") also.

gauravs0002 · Answer

Hi Sunil 
 use the date function ""month. 
 month( local!month_selected)