Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Jim,
Try like,
Month(Date#(MonthField,'M')) as Month
You can use
Month(MakeDate(Year(Today()),Month,'01')) as Month
Month is DUAL field (Text and Number).