Forum Discussion
Ramyaajithkumar
3 years agoFrequent Visitor
How to mention moth name
instead of numeric, i want to mention the month name, can anyone help me how to get to month name here?
BA_Pete
3 years agoSuper User
Hi Ramyaajithkumar ,
There's a couple of ways to do this. In order of preference:
1) If your data has an actual date field in it, then you would create a new custom column a follows:
Date.MonthName([Date])
2) If your data does not have a date field in it, then you would need to create a conditional column, something like this:
if [Month number] = 1 then "January"
else if [Month number] = 2 then "February"
else if [Month number] = 3 then "March"
...
Pete