Converting month to its number

[Raaghuik1996]

Hi,

I have a column in a schema containing name of the month like Jan, Feb....etc & I want to convert the name of the month to its specific number like Jan = 01, feb=02...ect in the enrichment activity after pulling it from schema

Kindly help if any inbulit function will sort the issue for me

Regards,

Raaghu

[Milan_Vucetic · Accepted solution]

Hi @Raaghuik1996

create new column with this expresion:
Iif(@column='January','1' , Iif(@column='February','2' ,Iif(@column='March','3' ,Iif(@column='April','4' ,Iif(@column='May','5' ,'Other')))))

Adjust source column name and other months.

In case you have dates in some column you can use built in function for month number Month (<Date>)

Regards,

Milan

[Raaghuik1996]

it works Thanks!!

[Sukrity_Wadhwa]

Hi @Raaghuik1996 ,

Were you able to solve this with the given help? Do let us know.

Thanks!