Hi All, Is there any function which returns the month name. If we give a date in

You'll be wanting the text() function. For example, text(today(), "MMMM") returns "March". The full list of formats is available here: forum.appian.com/.../Text_Functions.html

I don´t think so. But you can try this workaround using date with displayvalue function:


displayvalue( month(date(2016,2,10)), {1,2,3,4,5,6,7,8,9,10,11,12},
{"January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"}, "")

Note: those links will help you understand
forum.appian.com/.../Date_and_Time_Functions.html
forum.appian.com/.../Conversion_Functions.html

Not sure why you'd do that when the text function can do this out-of-the-box?

Thanks all. Would it be better if we have a function, specially in case, e.g today's date is something in march and we want month as previous (February) or other.

Philb you´re right. I didn´t know we could do this using text function. Thanks very much!

No problem!

you can use text function and as well as month() function as well to achieve this.

I am sorry only text function can be used to achieve your use case , as month function return type is integer value.