Date format in template/report

Tekla Structures Date révision Date format template report
Not version-specific
Tekla Structures
Environment
Not environment-specific
Question: 
In a revision template, we need the date format as "02-Jan-2017". Is it possible to have the date output in this format?

Answer:
To get the month to show up in a revision template or report, use the formula below in the date 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)


Sample report image is attached for reference.

Was this helpful?