Is it possible to format the time value of a time ...
# administration
k
Is it possible to format the time value of a time of day field in an email template? It's displaying at hhmmss when I want it to just be hh:mm.
s
TO_CHAR({string}, ‘HH24-MI’)
k
Interesting! I hadn't thought of that. I ended up going with ?time and ?string.short
Copy code
<#if customrecord.custrecord_appointmenttime?has_content>
        <#assign apptTime = customrecord.custrecord_appointmenttime?time>
        <#assign apptTime = apptTime?string.short>
    <#else>
        <#assign apptTime = ''>
    </#if>