How to convert month(interger type) to string(name of month)?

Hi all!

As I mention above, I don't know how to convert month (Interger data type) to string data type(Name of Month) in aggregate or expression.

Example: 1->January, 

                3->March.

Warm Regards,

Huy,


Hi Huy,

these are some fuctions to conver data, maybe this can help you https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Built-in_Functions/Data_Conversion

regards.




Omar Alejandro Soto Anaya wrote:

Hi Huy,

these are some fuctions to conver data, maybe this can help you https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Built-in_Functions/Data_Conversion

regards.




Hi Omar Alejandro Soto Anaya,

I have already checked that list data conversion but couldn't find suitable function. Could you please be more specific about how to conver int (1->12) to name of month ?



Solution

Hi Huy, 

I don't think there is a function for that. 

You could create a new date with your month and use the date to text conversion with the mmm format (it will give the month name). 

Or you can just write a function that receives an integer and return the name of month as output using a switch or a sequence of IFs. 

Cheers

Solution

Hi Huy,

try this solution posted in an older post https://www.outsystems.com/forums/discussion/37034/name-of-the-month/

regards.