Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
8 replies
Subscribers
7 subscribers
Views
6837 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi All, Is there any function which returns the month name. If we give a date in
kalpanap
over 8 years ago
Hi All, Is there any function which returns the month name. If we give a date in dd/mm/yyyy year format, 10/02/2016 to return february?
OriginalPostID-199816
OriginalPostID-199816
Discussion posts and replies are publicly visible
0
PhilB
A Score Level 1
over 8 years ago
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ederm160
over 8 years ago
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 8 years ago
Not sure why you'd do that when the text function can do this out-of-the-box?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
kalpanap
over 8 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ederm160
over 8 years ago
Philb you´re right. I didn´t know we could do this using text function. Thanks very much!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 8 years ago
No problem!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sparshs
over 8 years ago
you can use text function and as well as month() function as well to achieve this.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sparshs
over 8 years ago
I am sorry only text function can be used to achieve your use case , as month function return type is integer value.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel