Use Google to find help fast. For example, search on "xpressdox choosefromlist".

The FormatTime Function

The FormatTime Function

If a value has been captured as a time of day, then it can be formatted and inserted into the merged document in a format desired by the template author.  For example, a user may have captured a time in a 24 hour format, but it can be printed in the document in a 12 hour format:

«FormatTime(AppointmentTime,'hh:mm tt')»

The above would render a time entered in the form 13:50 as 1:50 pm.
and

«FormatTime(AppointmentTime,'HH:mm:ss.fff')»

would render the above time as 13:50:25.012 (meaning 25 seconds and 12 milliseconds after 1:50 PM).

Leave a Reply