February 15, 2022

Formatting the time (show am/pm) - XpressDox

The FormatTime command takes the HH or hh parameters to display the time in 24 or 12 hour time respectively, but what if you want to show the time in 12 hour clock, and display AM or PM? Here’s how:

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

Add an additional ‘tt’ to show the AM or PM.

Here are the two formats of the same time:

«FormatTime(AppointmentTime,'hh:mm tt')» «Comment(12 hour clock with AM or PM)»

«FormatTime(AppointmentTime,'HH:mm')» «Comment(24 hour clock)»