Switch syntax error

Question

I try to switch the month number to the month name as below, but the result is empty....... what's going on??

Please note that the month numbers bare int 16   Thank you.

Switch([MONTH], Null(),
"01","FEB",
"02","MAR",
"03","APR",
"04","MAY",
"05","JUN")

DanS · Accepted Answer

Try switching the month column to a String.

You can use a Select tool right before the Switch formula.

nick_ceneviva · Accepted Answer

Are you trying to create a new column or update the exiting Month column?

If you are updating the column, you should convert the month numbers to a string first using the Select tool.  If you are creating new column, your switch statement should work if you use the following:

SWITCH([Month], NULL(),

1, "Feb",

2, "Mar"

.....

)