Help require on string Month

[alt_tush]

Hi,

I have a below string column month with data

Month

Jan

Feb

Mar

I need expected output like month number for ex. for jan 1, feb 2 etc.

Expected output

Month    Month_No.

Jan        1

Feb        2

Mar        3

Please help

Thank you in advance.

[messi007]

@alt_tush,

Please see below:

Attached the workflow

Regards,

[AngelosPachis · Accepted solution]

Hi @alt_tush ,

Another way to do it apart from the one suggested by @messi007  is to use the formula 

DatetimeMonth(DateTimeParse([Month],"%B"))

The DatetimeParse([Month],"%B") is going to convert Jan, Feb, Mar to a date correctly formatted (yyyy-mm-dd) and the datetimemonth function will return you a numeric value for that month

Regards,

Angelos