템플릿/레포트에서 날짜 형식

Question: 
템플릿 변경에서 날짜 형식을 "02-Jan-2017"으로 표현하는 방법

Answer:
템플릿 또는 레포트에서 요구 사항과 같이 월을 표기하기 위해서 Value field에 아래 공식을 사용하십시오.

---

mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),3,2) + "-" +
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "01") then "Jan"
else
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "02") then "Feb"
else
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "03") then "Mar"
else
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "04") then "Apr"
else
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "05") then "May"
else
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "06") then "June"
else
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "07") then "July"
else
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "08") then "Aug"
else
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "09") then "Sept"
else
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "10") then "Oct"
else
if
(mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),0,2) == "11") then "Nov"
else
"Dec"
endif
endif
endif
endif
endif
endif
endif
endif
endif
endif
endif +
"-"+ mid(format(GetValue("DATE"),"Date","mm/dd/yyyy",0),6,4)

---