How to convert Month Number to Month Name in ACS

Question

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?

bisswang · Accepted Answer

There is no function to do this directly.What you could do is an expression like:Iif(Month()= '1', 'January', Iif(Month()= '2', 'February', ...))

RachaelAn · Answer

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'))))))))))))

Sign up

Login with SSO

Login to the community

Login with SSO