Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
In your script use:
MonthName(Date(Date#(Column, 'YYYYMM'))) AS MonthNameField
There are many other ways, but this one will work.
Miguel
Hi,
In your script use:
MonthName(Date(Date#(Column, 'YYYYMM'))) AS MonthNameField
There are many other ways, but this one will work.
Miguel
Thanks Miguel