How to convert Month Number to Month Name in ACS | Community
Skip to main content
G
GarimaGakhar1
Level 2
September 7, 2020
Solved

How to convert Month Number to Month Name in ACS

  • September 7, 2020
  • 2 replies
  • 2377 views

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?
 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by bisswang

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

    2 replies

    B
    Adobe Employee
    bisswangAdobe EmployeeAccepted solution
    Adobe Employee
    September 7, 2020

    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', ...))
    G
    GarimaGakhar1Author
    Level 2
    September 7, 2020

    Thanks a lot @bisswang.

    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.

    R
    RachaelAn
    June 23, 2023

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

    Terms & ConditionsAccessibility statement

    Loading footer...