Conversation of the Month field

[Anonymous]

HI Experts,

I am having one field in my script called " Month" in this field i am having the data like '01,02,03,04....12'.

NOw my question is i want get the month data like 'Jan,feb,....Dec'. How to change the number to string of the month field in script level?

Thanks in advance...

[sunny_talwar]

Try this

Month(Date#(Month, 'MM')) as MonthName

[shiveshsingh]

Month(Date#(dateField,'MMM'))