Expand my Community achievements bar.

SOLVED

How to convert Month Number to Month Name in ACS

Avatar

Level 2

I wish to display the Month Name for the incoming date values.

The in-built 'Month(<Date>)' function will fetch the Month number and not the Month name.

 

I browsed through some online documentation and was able to get hold of this:
https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/f-formatDate.html

But this seems to be applicable only for Classic and not Standard. 
I tried using these options in ACS, but they don't work.


Any idea how we could output Month Name in ACS Workflows results?
 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

There is no function to do this directly.

What you could do is an expression like:

Iif(Month(<Date>)= '1', 'January', Iif(Month(<Date>)= '2', 'February', ...))

View solution in original post

4 Replies

Avatar

Correct answer by
Employee Advisor

There is no function to do this directly.

What you could do is an expression like:

Iif(Month(<Date>)= '1', 'January', Iif(Month(<Date>)= '2', 'February', ...))

Thanks a lot @ramon_bisswanger.

I was aware of the If/Case statement and wanted to avoid that, hence thought of checking once if there is a way to achieve this directly in ACS.

Thanks a lot @ramon_bisswanger.
I was aware of the If/Case statement and wanted to avoid that, hence thought of checking once if there is a way to achieve this directly in ACS.

Avatar

Level 1

I just had to do this, for two months time. Here is is in case you want it:

 

Iif(Month(AddMonths(GetDate(), 2))=1,'January', Iif(Month(AddMonths(GetDate(), 2))=2,'Feburary',Iif(Month(AddMonths(GetDate(), 2))=3,'March',Iif(Month(AddMonths(GetDate(), 2))=4,'April',Iif(Month(AddMonths(GetDate(), 2))=5,'May', Iif(Month(AddMonths(GetDate(), 2))=6,'June', Iif(Month(AddMonths(GetDate(), 2))=7,'July', Iif(Month(AddMonths(GetDate(), 2))=8,'August', Iif(Month(AddMonths(GetDate(), 2))=9,'September',Iif(Month(AddMonths(GetDate(), 2))=10,'October', Iif(Month(AddMonths(GetDate(), 2))=11,'November', Iif(Month(AddMonths(GetDate(), 2))=12,'December', 'soon'))))))))))))