Options

Date Month Names - numbers to titles.

mikedmiked Member Posts: 21 Contributor II
edited November 2020 in Help

Hi All - Is there an easy way to convert Date Month Number (0,1,2,etc) into month names (Jan, Feb,etc) other than the below general if statement?

if(eval(%{Data_Month})==0,"January",
if(eval(%{Data_Month})==1,"February",
if(eval(%{Data_Month})==2,"March",
if(eval(%{Data_Month})==3,"April",
if(eval(%{Data_Month})==4,"May",
if(eval(%{Data_Month})==5,"June",
if(eval(%{Data_Month})==6,"July",
if(eval(%{Data_Month})==7,"August",
if(eval(%{Data_Month})==8,"September",
if(eval(%{Data_Month})==9,"October",
if(eval(%{Data_Month})==10,"November",
if(eval(%{Data_Month})==11,"December","N/A"))))))))))))

@sgenzler

Best Answer

Answers

Sign In or Register to comment.