Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Please try:
=SubField(MonthNames,';',MES)
May be try like this..
=Month(Date#(MES,'M'))
Thank you very much for the information
Thank you very much for the information
Thank you very much for the information
thank you very much for the information, the three forms serve to perfection.