how to change numeric month field to string month field

[jim_chan]

Hi guys,

i have a month field, with value (1 until 12), how do i convert that month field to string(Jan-Dec) in scripting?

Rgds,

Jim

[tamilarasu · Accepted solution]

Hi Jim,

Try like,

Month(Date#(MonthField,'M')) as Month

[antoniotiman]

You can use

Month(MakeDate(Year(Today()),Month,'01'))  as Month

Month is DUAL field (Text and Number).