Month to Month Number text

[#1]

Good Morning

As I can convert the month field is numeric and take the value corresponding text

1 - Jan

2 - Feb .. to reach 12 - Dic

But this field is stored in a SQL Server table where only this number between 1 and 12, the display information

It is shown as follows:

but I need to be displayed as follows.

and and tried to MonthName but it does not work, any help is appreciated them.

[marcus_sommer]

For monthname() you need a real date-field. Isn't there such a field you could one create with makedate(). But it could be easier simply to map these values with a pick(match()) funtion like:

pick(match(MES, 1,2,3,...), 'Ene', Feb', ...)

- Marcus

[Clever_Anjos]

Please try:

=SubField(MonthNames,';',MES)

[settu_periasamy]

May be try like this..

=Month(Date#(MES,'M'))

[#5]

Thank you very much for the information

[#6]

Thank you very much for the information

[#7]

Thank you very much for the information

[#8]

thank you very much for the information, the three forms serve to perfection.