MonthName Issue

[vanderson009]

Hello Community,

I have column in my table with values are,

201303

201304

201305

201306

201307

201308

201309

201310

201311

201312

201401

and i want Month Name from this data.

please if any one of you know then help me its urgent.

- Thanks and regards,

Villyee

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

In your script use:

MonthName(Date(Date#(Column, 'YYYYMM'))) AS MonthNameField

There are many other ways, but this one will work.

Miguel

[vanderson009]

Thanks Miguel