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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

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

Avatar

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.

Avatar

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.