Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

How to convert Month Number to Month Name in ACS

GarimaGakhar1
Level 2
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
ramon_bisswanger
Correct answer by
Employee
Employee

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

3 Replies
ramon_bisswanger
Correct answer by
Employee
Employee

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

GarimaGakhar1
Level 2
Level 2

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.

GarimaGakhar1
Level 2
Level 2

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.