Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

Converting month to its number

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Administrator

Hi @Raaghuik1996 ,

 

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

 

Thanks!



Sukrity Wadhwa